I have a database that I have designed for my laboratory. In this database I have several forms based on 1 table. The table has 1 autonumber field called Insp Rec #. Each form has fields from the table but are only opened and used based upon the type of test the lab tech. will perfomr. Once anyone of the forms is opened there is the appropriate fields for the test that will be performed. The form when data is entered automatically assigns a Insp Rec #. I also have a button on each form that opens a results form. The fields on this form need to be associated to the Insp Rec #. Without the tech having to input the number. I want results form to automatically go to the record which was assigned by opening the first form.
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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Help With Synchronizing Form Data
- Thread starter tpearo
- Start date
- Thread starter
- #2
I have a database that I have designed for my laboratory. In this database I have several forms based on 1 table. The table has 1 autonumber field called Insp Rec #. Each form has fields from the table but are only opened and used based upon the type of test the lab tech. will perfomr. Once anyone of the forms is opened there is the appropriate fields for the test that will be performed. The form when data is entered automatically assigns a Insp Rec #. I also have a button on each form that opens a results form. The fields on this form need to be associated to the Insp Rec #. Without the tech having to input the number. I want the results form to automatically go to the record which was assigned by opening the first form.
Shoot I didn't finish and sent the thread prematurely.
I know I could have used a tab form but did think I needed it until I got to this part of the project. I need all the forms to look the same so I don't want to go back and redo the forms to tab.
Any help would be appreciated.
Tp
Shoot I didn't finish and sent the thread prematurely.
I know I could have used a tab form but did think I needed it until I got to this part of the project. I need all the forms to look the same so I don't want to go back and redo the forms to tab.
Any help would be appreciated.
Tp
Hi tpearo,
Redesigning your form to a tabbed form isn't that much work! You can just drag and drop the forms onto the tabbed form. Make sure you set the Link Child/Master Field-property right in your subform, that will be InspRec#.
Pampers -
you're neven too young to learn
Redesigning your form to a tabbed form isn't that much work! You can just drag and drop the forms onto the tabbed form. Make sure you set the Link Child/Master Field-property right in your subform, that will be InspRec#.
Pampers -
you're neven too young to learn
- Status
