Form field not populating table

[dailyxe]

I am trying to populate a field in a table based on the Autovalue in a form.

My query has a value of the form, and ID but it populates the field in the table with [] instead of say, 3 which is actually displayed on the form field. if i create an unbound text field on the form and manually type in 3, repoint the query, it works as it should but i need it to populate based on the Autovalue. This stopped working last week and cant see why.

 

[arnelgp]

is the data already in the table or new record?

 

[Pat Hartman]

The values of unbound controls are not saved to the underlying table. Controls that are unbound have no Column name as their ControlSource so Access would have no idea of what column the data should be saved to.

If you have a default defined for a control on a form, that default is applied to NEW records only. So if you added the default after you created the record, the default would not be saved. When you add a default after you have data in the table, you need to run an update query to populate the empty rows. Be careful to not overlay existing data with the default value.