AnOddExperiment
Registered User.
- Local time
- Today, 17:01
- Joined
- Dec 10, 2007
- Messages
- 20
That works great! Your a godsend. I've been doing some reading on your website and looked at the example for requery, trying to use it to solve really the last roadblock between being able to get the lab started with a functional model of the database.
If you notice on the database attached above, frmTestResultEntry is really the crux of the entire database which is designed to input micro data as recorded by laboratory personnel. I was able to successfully design a form which both displays the required tests and has a section to enter the results simply by picking a lot number from the top of the page. After trying to populate the database, however, I found that the form will only record data one time for any given sample type instead of for each batch number regardless of sample type. I've also noticed that it does not record the batch number in the table tblTestResults.
What I would like is a form that allows the user to select a lot number from a combo box that only displays lots with missing results and then displays the tests and results column for that batch number based on it's type and the requirements of that type. Is that possible?
If you notice on the database attached above, frmTestResultEntry is really the crux of the entire database which is designed to input micro data as recorded by laboratory personnel. I was able to successfully design a form which both displays the required tests and has a section to enter the results simply by picking a lot number from the top of the page. After trying to populate the database, however, I found that the form will only record data one time for any given sample type instead of for each batch number regardless of sample type. I've also noticed that it does not record the batch number in the table tblTestResults.
What I would like is a form that allows the user to select a lot number from a combo box that only displays lots with missing results and then displays the tests and results column for that batch number based on it's type and the requirements of that type. Is that possible?
