Thanks, Jim. That's exactly what I was doing but in a FormsOpen event. I was able to get it to work after I cleaned up the data (the ID was coming from an RDB database and was text. I changed them all to integer) and put the Dlookup in the FormsLoad<br>event. One or both changes seemed to do the...
If have a form with a 6 page tab control. The form's control source is a query that selects all records from 5 (one to one) tables. The form should allow the user to add a new record to each table in one update. <br><br>In the Form Open Event, I am updating a value in a table that holds the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.