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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Link several forms through ID number
Hi and thanks again... I've built a very basic model of the database I have, just to test the open event as you described, and I've eliminated the command buttons. I now have simple three-form database with a few questions in each, all linked by HOSPITALID. Here is the code in the code...- bklyn123
- Post #7
- Forum: Microsoft: Access Forms
-
Link several forms through ID number
Thanks very much both of you...couldn't figure out how to retrieve the value through [Forms] so I tried what Paul suggested. Private Sub Form_Open(Cancel As Integer) Me.HOSPITAL_ID = Forms![INITIAL FORM]!HOSPITAL_ID End Sub I get a message box saying cant find INITIAL FORM. My form is named...- bklyn123
- Post #4
- Forum: Microsoft: Access Forms
-
Link several forms through ID number
Hi, I'm relatively new to programming in Access (meaning I dont really know how to use modules yet)...Nevertheless, I'm trying to build a database with several forms for data entry, and I want to enter an id number in the first form and have it automatically fill in as the data entry staff open...- bklyn123
- Thread
- Replies: 7
- Forum: Microsoft: Access Forms
