Start options change subform update?

C

CarinKg

In a database I have a subform. The record source for this depends on two
succesive select-queries. Their sql content, set by VBA code, depend on
settings in the main form.
The subform works well, but only if I've used the shift-key to bypass an
AutoExec macro, ie when I'm redesigning it. When I start the DB in the
normal way, the subform either don't update the content according to settings
in the main form, or crash. No error messages.
The Start options for the database hide the database window, hide full menus
etc to prevent normal users from changing the design
The DB is designed in Access 2002, on a WinXP, all uppdated.
Suggestions on what's wrong and/or how to work around it?
 
T

Tom van Stiphout

On Tue, 11 Dec 2007 00:28:01 -0800, CarinKg

If you suspect that the startup options contribute to the problem
you're observing, temporarily comment out that code and try again.

-Tom.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top