B
Beatha Galloway
Guest
I have a database that I've just about completed. There are forms that are attached to a main form by command buttons. These buttons opens each form and allows the end-user to enter data. While on the main form the 2 identifiers that distinguishes one record from the other are the facility id (primary key) and the hotel name fields.
When the end user chooses to go to any of the other forms, the facility id and hotel name should automatically be entered (locked) to distinguish that the end-user is still on the same hotel's record entry. If I set the field expression to read these fields, the information is not entered or locked into the field. Therefore, when I go into the table where the information should be, there is only the information that was entered and the 2 fields that I need to carry over are blank. Because the facility id is a primary key, the program is not allowing the end-user to enter this information again, not to mention that this defeats the purpose of having a handy database like access.
In a nut shell I need the program to remember and write the information in these 2 fields from one form to another, and I can't get it to successfully do that. Can you help, please?????
When the end user chooses to go to any of the other forms, the facility id and hotel name should automatically be entered (locked) to distinguish that the end-user is still on the same hotel's record entry. If I set the field expression to read these fields, the information is not entered or locked into the field. Therefore, when I go into the table where the information should be, there is only the information that was entered and the 2 fields that I need to carry over are blank. Because the facility id is a primary key, the program is not allowing the end-user to enter this information again, not to mention that this defeats the purpose of having a handy database like access.
In a nut shell I need the program to remember and write the information in these 2 fields from one form to another, and I can't get it to successfully do that. Can you help, please?????