Dave 14867
Registered User.
- Local time
- Today, 07:47
- Joined
- Jan 1, 2017
- Messages
- 56
Hello all,
I have started a new database for tracking some info and have run into a snag. I have 2 tables, the first was created with imported from an excel file I was using and the second was created to start to track info on a per machine basis.
I need to have the second table "Instrument Issue Log" to be populated with some info from the first table when it opens, namely the "Instrument Serial_Num" and "Instrument_ID". I can seem to remember how to get the code correct to be able to access that info in the first table.
I want the form to open from the "Instrument History - Columnar" Table "Log Issue 3" Command button (Going to remove other buttons) and when the form opens have the fields already populated, or they can populate after the user enters their name.
I hope I have described my problem correctly.
I have attached the database.
Thanks
Dave
I have started a new database for tracking some info and have run into a snag. I have 2 tables, the first was created with imported from an excel file I was using and the second was created to start to track info on a per machine basis.
I need to have the second table "Instrument Issue Log" to be populated with some info from the first table when it opens, namely the "Instrument Serial_Num" and "Instrument_ID". I can seem to remember how to get the code correct to be able to access that info in the first table.
I want the form to open from the "Instrument History - Columnar" Table "Log Issue 3" Command button (Going to remove other buttons) and when the form opens have the fields already populated, or they can populate after the user enters their name.
I hope I have described my problem correctly.
I have attached the database.
Thanks
Dave