Form field not populating table (Append)

[Lochwood]

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.

 

[Ranman256]

the text box formula will not update until you Save the record.
when the record saves, THEN the autonum is created, THEN your text field will create.

you can always run a bulk update query to update the calculated field based on the autonum.
It doesnt have to happen at creation, but at the form.Afterupdate event, run the calculation here too.