Access Macro

[MichelleM]

I am working on a project and I am opening a table then using queries from
then on to sort through my data. I need to initially enter a date or edit a
date on the table and then run the queries but as I have it now it just opens
the table and runs straight through everything without the option to edit..
Can someone help thanks

 

[Steve Schapel]

Michelle,

The general concept with Tables is that their purpose is storage of data.
In production usage, they should never be seen, nor used for entering or
editing data. This is the purpose of Forms. I expect that if you open a
form based on your table, you will be able to then put a command button on
that form which can be used to perform the next steps, after you have made
your required data edits.

 

[MichelleM]

So I get that i need to make a form but im still not understanding how to
make the macro open the form enter a date and then continue to run the rest
of the macro.. is that possible?

 

[Steve Schapel]

Michelle,

There are 2 ways to do this.

One is, in the OpenForm macro action, there is a 'Window Mode' argument, and
setting that to 'Dialog' will do what you want.

The other way, which is what I was trying to suggest before, is to take all
the Actions after the OpenForm out of the macro into another macro, and then
run that as a separate event when the user clicks the 'OK' (or whatever)
button on the form.