Startup query

[erikl1]

Is there any way I can open an access 2010 database with a startup query? I want my starting screen to be a query that is identical to a form.

[June7]

Maybe with an Autoexec macro. Why? How would a query be identical to a form?

[erikl1]

Different, different - but same, same . The query I want to use is graphically identilcal to a form into which I will put data. The startup procedure is to identify record that contains some of the information I want to put in a new record. I copy the old record (identified by information collected from the query), and do the required modifications. The procedure saves me for lots of typing.


My startup procedure (which was easy to make in earlier versions of Access) is thus to have an empty query (lookin just like the record I am about to make). I have not yet figured out how to make this query a starting screen.

[June7]

I just tested an creating an Autoexec macro that opens a query. It works. This helped me create macro http://www.vb123.com/toolshed/05_map/ch04_autoexec.htm