Data set is not loading on start up form

[Gwen]

Please help?

When I use a start up form with autoexec the data is not
loaded in the text boxes. The data shows up on the combo
boxes but not the text boxes. Also, if I close the form
and reopen the form, the data is there. There is a make
table query that runs before the form opens as part of
autoexec macro. When I disable autoexec and open the form
manually the data is loaded on the text boxes. What
gives? Please tell me what I am doing wrong?


Thanks

Gwen

 

[Lynn Trapp]

What is the data mode set to in the Open Form line of the Autoexec macro? It
it is set to Add, change it to Edit.

 

[Gwen]

Thank you so much.
It worked like a charm.

-----Original Message-----
What is the data mode set to in the Open Form line of the Autoexec macro? It
it is set to Add, change it to Edit.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm





.

 

[Lynn Trapp]

You are very welcome, Gwen