lorenambrose
Active Member
- Joined
- Sep 17, 2008
- Messages
- 265
I have the following setup:
1. Form called "Master Details" and is linked to the "Master Library" table.
a) the table has fields for "ID", "Part Number", "Revision", "Release Date", "Description"
b) the form "Master Details" has text boxes linked to these fields
-------------------------------------------------------------------------------------------------
2. Form called "Details" and is linked to the "Software Control" table.
a) the table has fields for "ID", "Part Number", "Revision", "Release Date", "Description"
b) the form "Details" has text boxes linked to these fields
-------------------------------------------------------------------------------------------------
What I want to do is create an UNBOUND text box on the details form that when the ID of a record in the "Master Library" is entered and when a command button is clicked:
a) If the ID does not exist in the "Master Library" table a message box tells the user "No Such Record" and nothing else happens.
b) If the ID does exist in the "Master Library" table then the "Part Number", "Revision", "Release Date", "Description" information for the record in the "Master Library" table is entered into the "Part Number", "Revision", "Release Date", "Description" text boxes of the "Details" form.
Can someone help me with this?
1. Form called "Master Details" and is linked to the "Master Library" table.
a) the table has fields for "ID", "Part Number", "Revision", "Release Date", "Description"
b) the form "Master Details" has text boxes linked to these fields
-------------------------------------------------------------------------------------------------
2. Form called "Details" and is linked to the "Software Control" table.
a) the table has fields for "ID", "Part Number", "Revision", "Release Date", "Description"
b) the form "Details" has text boxes linked to these fields
-------------------------------------------------------------------------------------------------
What I want to do is create an UNBOUND text box on the details form that when the ID of a record in the "Master Library" is entered and when a command button is clicked:
a) If the ID does not exist in the "Master Library" table a message box tells the user "No Such Record" and nothing else happens.
b) If the ID does exist in the "Master Library" table then the "Part Number", "Revision", "Release Date", "Description" information for the record in the "Master Library" table is entered into the "Part Number", "Revision", "Release Date", "Description" text boxes of the "Details" form.
Can someone help me with this?
