I have a form and subform that when opened prompts user for id#. The id# number is the criteria for the form, the user then enters new records into the sub form. The user then must close form and re-enter in order to get promted for criteria again.
I have tried to put a button on the form to refresh, but that doesn't bring up the prompt. Is ther code or something that I can use to make the form refresh and prompt user for id# without having to close and re-open? Where should the code be put?
how did you manage asking id# to user when the form opens? I'm just trying to understand what you have done, so I can advice something. either if you can attach your database to thread so I can look at.
The form's row source is a query of tbl.submissions, with criteria for id# being [Enter Id#], the subform is linked to the form by this number. By entering the id# the main form shows info from tbl.submissions, and the sub-form shows all data from tbl.rfq. Hope this helps. The database has user-level security so I don't think you would be able to open it Thanks for your time, I really have tried many options and have not found a solution yet.
ok I will give you a step by step workaround for that problem, but you really need to work on learning some VBA if you want to continue developing on Access.
1. create a new button, don't use wizard.
2. right click on the button and choose Build Event...
3. you will go to VBA code editor at this point
4. add the line below between private sub and end sub lines