Form problem

[PsyberFox]

Hi there,

I have an input form to capture records to linked SQL tables. the one form
opens up with a blank screen on a new record, which is right. The other form
opens up with a record loaded... I've looked at every single property for the
form, but cannot see a difference between the two forms. Also, the tables
that the forms are linked to are identical in setup.

Can you help?!

 

[John W. Vinson]

Hi there,

I have an input form to capture records to linked SQL tables. the one form
opens up with a blank screen on a new record, which is right. The other form
opens up with a record loaded... I've looked at every single property for the
form, but cannot see a difference between the two forms. Also, the tables
that the forms are linked to are identical in setup.

Can you help?!

Check the "Data Entry" property of the two forms. If the two forms are
identical they will behave identically; all I can conclude is that you missed
something.

You can put code in the form's Load event

DoCmd.GoToRecord acDataForm, Me.Name, acNewRecord

to jump to the new record.