It's been a while since I've posted here but you all have been awesome in your help. Here's my new project. Form is opened with a select sql statement as recordsource which selects fields from 3 tables. I want to add a field to the form to show who made the last change (have code already for this). What I can't figure out is how to get the txtbox bound to all three tables and ensure it's inputting the Environ("USERNAME") to the right record. Hope this makes sense.
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL statement as Form Recordsource
- Thread starter newestAF
- Start date
A text box is bound to a single field in a single table not all three tables. You can set a default value of a text box to a value that identifies the user. If you want to identify who modified a record, you need to use code in the Before Update event of the form.
Duane
Hook'D on Access
MS Access MVP
Duane
Hook'D on Access
MS Access MVP
- Status
Similar threads
- Locked
- Question
