I have to close and open program to make it work

[wthoffman]

I have deployed the application through Access Runtime. After entering the
information into tables through forms, I need to close the program and open
it in order for the query to work for reports.

 

[Arvin Meyer [MVP]]

Change your code to save the record and/or requery the form after the data
entry. Then the data will be available.

 

[wthoffman]

How do I do that? I am new to Access

Change your code to save the record and/or requery the form after the data
entry. Then the data will be available.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[wthoffman]

How do I do that? I am new to Access

Thank you for your advice but where do I change the code. I am afraid I
need step by step instructions.

Thanks

 

[Arvin Meyer [MVP]]

Arvin,
Thank you for your advice but where do I change the code. I am afraid I
need step by step instructions.

Open the form in design view.

Open the form's property sheet, either from the menu, or by double-clicking
on it.

You can use another event, but it may be easier just to add a button.

If the toolbox wizard (the magic wand) is turned on, when you place the
button on the form, a wizard will guide you through the code.

Choose Record Operations then Save Record

Directly below the line that begins with: DoCmd, add a line:

Me.Requery

Save and close the form. Test it.

 

[wthoffman]

Open the form in design view.

Open the form's property sheet, either from the menu, or by double-clicking
on it.

You can use another event, but it may be easier just to add a button.

If the toolbox wizard (the magic wand) is turned on, when you place the
button on the form, a wizard will guide you through the code.

Choose Record Operations then Save Record

Directly below the line that begins with: DoCmd, add a line:

Me.Requery

Save and close the form. Test it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


Thank you very much