i have created an equipment/maintenance database...i have a subform within a form, that when opened requires a serial number to be entered and then goes away and retrieves certain records(this is the subform)...the main-form requires the user to input other data. But, when you open the form to view the data later, the data from the subform is not there...please help me!!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Retrieving Records (going nuts....)
- Thread starter pmbryant
- Start date
I am not sure of the correct procedure but if you are opening the subform and then closing it after it has got the new information that you keyed you may have to refresh the main form or subform or even both when closing the subform.
If you have a "Close" button of the subform go into the code and on the next line after the "docmd.close" type "docmd.requery "nameofsubform"
ie - docmd.close
docmd.requery "nameofsubform
If not try
docmd.close
docmd.gotocontrol "nameofsubform"
docmd.requery "nameofsubform"
Or it may be a case of refreshing the forms after closing the sub form. A requery may take you back to the first record for the main form
If you have a "Close" button of the subform go into the code and on the next line after the "docmd.close" type "docmd.requery "nameofsubform"
ie - docmd.close
docmd.requery "nameofsubform
If not try
docmd.close
docmd.gotocontrol "nameofsubform"
docmd.requery "nameofsubform"
Or it may be a case of refreshing the forms after closing the sub form. A requery may take you back to the first record for the main form
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
