onopen event

[rikklaney1]

I have a form that the on open event sets a couple of values in text boxes depending on what time the form is opened. This works fine when I open the form through a button click but when opened through vba it doesn't set these values. Any ideas why it only skips it when using vba?

 

[sneuberg]

How are you opening the form through VBA? Please post the code. Does the button use VBA to open the form or is it a macro?

 

[Ranman256]

Use form load. (Not open)

 

[rikklaney1]

I had a docmd.openform "form name" on a timer to open the form from another form. Everything worked fine when opening the form manually or with a button click but using the timer it didn't work with onopen or onload. I imported everything into a new database and now it is working. Thanks anyway guys.