Can't go to specified record...

[Voodeux2014]

Private Sub Form_Load()


On Error GoTo Form_Load_Err
DoCmd.GoToRecord acForm, "frmAddDevices", acNewRec
Form_Load_Exit:
Exit Sub
Form_Load_Err:
MsgBox Error$
Resume Form_Load_Exit
End Sub

This is the the code that is ran only when the specified form is opened. It did not occur until I changed the model field from manual entry to a combobox.

[Missinglinq]

Well, acForm is not a valid parameter for DoCmd.GoToRecord! Try replacing it with acDataForm and see what happens.

Or even simpler

DoCmd.GoToRecord , , acNewRec

If you keep getting the same error message, you've probably done something to make the Form Read-Only. Can you edit a Record, or create a New Record, using the native nav buttons on the Form?

Linq ;0)>

[Voodeux2014]

The new record option is greyed out on the navigation bar when I enable it. Let me try to change what you said and see what I get.

[Voodeux2014]

Still same message. Allow additions is set to Yes. RecordSet Type is set to Dynaset. Not sure what else to check to make sure that it is not set to read only.

[Missinglinq]

Can you edit an existing Record? If not then obviously something changed when you changed the model field's Control from a Textbox to Combobox.

Linq ;0)>

[Voodeux2014]

Yea. It is saying this recordset is not updateable. Should I just create a new form and see if I can get it to work?

[Voodeux2014]

Ok. So it seems to be something with the tbl1Devices table. I have it linked front the _be of the database. When I open the table in the BE it is fine. Opening it on the front end will not even let me manually add a record to the table. Any ideas?