G
Guest
Help!
i am working on a major component of our companies service department
database and need some help with forms and sub forms.
i have a picture to show what i am doing. see this pic:
http://img156.imageshack.us/my.php?image=formsubformsubsubformpinx0.jpg
it shows the layout of the screen that i am creating to be able to enter in
all the data pertaining to the machines we build.
the problem is with some code that i am building in the red boxed subform to
update the blue box subform.
this is the code, borrowed from a tip site:
Private Sub Form_AfterUpdate()
Forms!subfrmUnitsAddressEquipDetails.subfrmDecendingRunningHoursatDate.Form.Requery
End Sub
it worked untili i moved the subform to being a subsubform.
another question on this topic is, how many layers can i go?
i am working on a major component of our companies service department
database and need some help with forms and sub forms.
i have a picture to show what i am doing. see this pic:
http://img156.imageshack.us/my.php?image=formsubformsubsubformpinx0.jpg
it shows the layout of the screen that i am creating to be able to enter in
all the data pertaining to the machines we build.
the problem is with some code that i am building in the red boxed subform to
update the blue box subform.
this is the code, borrowed from a tip site:
Private Sub Form_AfterUpdate()
Forms!subfrmUnitsAddressEquipDetails.subfrmDecendingRunningHoursatDate.Form.Requery
End Sub
it worked untili i moved the subform to being a subsubform.
another question on this topic is, how many layers can i go?