Forms and Autoexc Error

[markrewel]

Hi I have created a access database the form has mutliple dynamic drop down lists.
When I add a autoexeC to open the form from start up, the form loads ok, when I enter the text fileds this is fine, but as soon as I chosse a drop down list it restets the form, creates an entry on the table and gives me a new form to work with?



Any advice

Thanks
Mark

[Minty]

What code is behind form open event, and how are you opening the form from the Autoexec ?

[markrewel]

Throught Macro - open form --view(form name) conditon Add.

if it helps their are two drop downs that create the issue, the second of the dropdown is dependant on the first dropdown - its when I click this it clears all data, completes the form and gives me new form. the two dropdown are requeried etc - im at a loss as I have similar sheet that has no issues and more of less identicle and cant identify the issue.

[Minty]

Okay so you are opening the form onto a New record.

So is there some event or macro on the combo's that is then doing that again?
You can prevent that by adding in something like

If Me.NewRecord Then Exit Sub

to stop the code running on a new record.

[markrewel]

Hi I cant see any untoward macro - the only macro on the event is the Requery -

For the

If Me.NewRecord Then Exit Sub - where does this go? form or the combo?

Thanks
Mark

[Minty]

Are you re-querying the form or the second combo? If you requery the whole form it will force a save, and possibly start the process all over again.