Form not working after editing a new record

[mokje5]

Hey,

I have a form with a combobox, where you can select a movie.
When a movie is selected, the corresponding information is shown in comboboxes, which you can use to change/view data about the selected movie.
There is also a button to create a new blank record to add a new movie, this button uses the following VBA:

DoCmd.GoToRecord , , acNewRec
Me.save_button.Visible = True

The above works fine, I can use the newly created blank record to make a new movie, and insert it in the database.
But when I try to click on a movie in the combobox AFTER adding a new movie it doesn't show the info of the movie.
I've tried to use Me.Refresh, Me.Requery but those just result in errors when using them after making the new record.
Also, the problem starts occurring when info is typed into the newly created record.
When nothing is typed in, you can just click on a movie in the combobox and it will show the info.



I hope you guys can help!

[RuralGuy]

Not real sure what you are doing but have you saved the "new" record yet?

[mokje5]

Yes, there is a save button with a query.

[RuralGuy]

Have you "requeried" the ComboBox? Me.ComboBoxName.Requery

[mokje5]

Yup, it doesn't change the situation unfortunatly.
I've just discovered that when using the record navigator at the bottom(the new record does in fact get saved), I get this error after saving the new record.

[RuralGuy]

So SQL Server is your back end?

[mokje5]

Yes it is indeed.

[ItsMe]

Movie-id is not a nullable column. Before you can navigate from one record to another, you need to provide values for each column that is not nullable.

After navigating to a new record, if you do not type anything into any of the controls, you can navigate back to previous records. This is because Access is not trying to save a new record. You did not enter anything, so the new record is aborted.

[mokje5]

Movie-id is not a nullable column. Before you can navigate from one record to another, you need to provide values for each column that is not nullable.

After navigating to a new record, if you do not type anything into any of the controls, you can navigate back to previous records. This is because Access is not trying to save a new record. You did not enter anything, so the new record is aborted.

What would be the easiest way to solve this problem?

[ItsMe]

Provide a value for Move_id before navigating to a new record or closing the form.