Changed Links now Form Opens In Edit Mode Not Add

[LCM]

I updated my tables in my linked table manager to tables with exact same table names etc just more up to date data.



however now when i open up my form using my switchboard it opens a record that already exists not a new record.

i have tested this and it is definitely due to me changing my links but i do not understand the table names etc are all the same! just a different ODBC source.

Do i need to change something somewhere?

[ranman256]

change the command to open the form

docmd.openform "myform",,,,acFormADD

[LCM]

sorry im confused on where i enter this?

[Homegrownandy]

click your button > In the property sheet on the right click the event tab > click the three dots on the on click event (this will open the macro up) > click the drop down on data mode > Change to add.

easy when you know how

[LCM]

its not a button though? its my switch board?

[Homegrownandy]

Doesn't your switch board consist of several buttons?

[LCM]

Nvm sorted thank you