S
schmoopiesdad
Hi and Thank you -
I'm crreating an inventory control database for an experimental animal colony.
I have a form with with seven subforms - each of which has a particular piece
of info about the animal - frmStudyUse which gives a list of the studies of
which the animal has been a part in datasheet format. For each of these forms
I have a button which opens a form to add a new entry to the available list -
ex. frmStudyUseAddName - which the user can access while updating the
particular animal's record instead of going back through several layers of
switchboards. Fairly strightforward.
Here's the problem - I can get the subforms to update once, but if you need
to open the frmStudyUseAddName a second time, the requery will not work.
I've tried both these codes:
Forms.frmAnimalInformation.frmStudyUse.form.requery
and
Me.frmAnimalInformation.frmStudyUse.form.requery
Can you tell the problem?
Ike Horton
I'm crreating an inventory control database for an experimental animal colony.
I have a form with with seven subforms - each of which has a particular piece
of info about the animal - frmStudyUse which gives a list of the studies of
which the animal has been a part in datasheet format. For each of these forms
I have a button which opens a form to add a new entry to the available list -
ex. frmStudyUseAddName - which the user can access while updating the
particular animal's record instead of going back through several layers of
switchboards. Fairly strightforward.
Here's the problem - I can get the subforms to update once, but if you need
to open the frmStudyUseAddName a second time, the requery will not work.
I've tried both these codes:
Forms.frmAnimalInformation.frmStudyUse.form.requery
and
Me.frmAnimalInformation.frmStudyUse.form.requery
Can you tell the problem?
Ike Horton