I am an accountant and not a programmer, but am trying to finish this database for my internal audit group as we have no support for this. I currently have a form that is used to enter data into a few fields. I have about 25 users that will enter data and a table set up for each user to capture the data. I will have the back end database on a network drive and the front end on each of the user’s laptops. A function determines the network ID for the specific user on each PC. I have the tables named after each user’s network ID. Is there some code that can be entered in the record source field of the form so that depending on the result of the function, the correct table stores the data? I know this is probably very basic to everyone here, so let me apologize in advance for being so ignorant. Thanks.
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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Mutliple Record Sources
- Thread starter Roblin
- Start date
Similar threads
- Locked
- Question
- Locked
- Question