nepotist
09-03-2008, 08:35 AM
If CurrentProject.AllForms("ProjectEdit").IsLoaded = True Then
LinkID = Forms!projectedit.!Processedtrips.!LinkNumber.Value
projVol = Forms!projectedit!Processedtrips!LinkTrips.Value
TripType = Forms!projectedit!Processedtrips!Type.Value
ExcCap = Forms!projectedit!Processedtrips!AvailCap.Value
Else
LinkID = Forms!NewProject!Processedtrips!LinkNumber.Value
projVol = Forms!NewProject!Processedtrips!LinkTrips.Value
TripType = Forms!NewProject!Processedtrips!Type.Value
ExcCap = Forms!NewProject!Processedtrips!AvailCap.Value
the above is a code that i have in my module.
there are basically to forms newproject and project edit forms that use processedtrips as a subform and based on the form active/loaded i would do the calculations
not i get an error 2465 with the above code
I am debugging using the stepin to function or f8 key and i make sure that one of the main forms that is newproject or projectedit form is open
It first gave me a error saying that there is no such form existing when the code was some thing like this
linkid = forms!form_newproject!form_processedtrips!linkid.value
so i removed the from word in front of the newproject and processedtrips and now is gives me an error saying that the field processedtrips not found so i add back the form word back to the processedtrips but still of no use
I even tried to code some thing like this
linkid = forms!newproject.form!processedtrips.form!linkid.value
still it isnt of any use
Please some one help with any clues and ideas
LinkID = Forms!projectedit.!Processedtrips.!LinkNumber.Value
projVol = Forms!projectedit!Processedtrips!LinkTrips.Value
TripType = Forms!projectedit!Processedtrips!Type.Value
ExcCap = Forms!projectedit!Processedtrips!AvailCap.Value
Else
LinkID = Forms!NewProject!Processedtrips!LinkNumber.Value
projVol = Forms!NewProject!Processedtrips!LinkTrips.Value
TripType = Forms!NewProject!Processedtrips!Type.Value
ExcCap = Forms!NewProject!Processedtrips!AvailCap.Value
the above is a code that i have in my module.
there are basically to forms newproject and project edit forms that use processedtrips as a subform and based on the form active/loaded i would do the calculations
not i get an error 2465 with the above code
I am debugging using the stepin to function or f8 key and i make sure that one of the main forms that is newproject or projectedit form is open
It first gave me a error saying that there is no such form existing when the code was some thing like this
linkid = forms!form_newproject!form_processedtrips!linkid.value
so i removed the from word in front of the newproject and processedtrips and now is gives me an error saying that the field processedtrips not found so i add back the form word back to the processedtrips but still of no use
I even tried to code some thing like this
linkid = forms!newproject.form!processedtrips.form!linkid.value
still it isnt of any use
Please some one help with any clues and ideas