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.
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.
