Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Field control sources
- Thread starter mgbeye
- Start date
You could have code to take the contents of the text box and put it into the two fields. You would need to write code to open two recordset objects and use the edit method to set the field's value.
Or you might be able to write a query, or set one up as a recordset using SQL, that incorporates the two fields from the two tables. Then you only need one recordset object.
I have not tried this so I am not sure if it will work.
Have fun! Alex Middleton
Or you might be able to write a query, or set one up as a recordset using SQL, that incorporates the two fields from the two tables. Then you only need one recordset object.
I have not tried this so I am not sure if it will work.
Have fun! Alex Middleton
- Status
