SmartestIdiot
New member
- Local time
- Today, 21:27
- Joined
- Dec 10, 2013
- Messages
- 4
I thought I had learned enough about Access over the past month, guess I thought wrong.
Building an HR Data Base using EmployeeID as the Primary Key. I have a Personnel Form with a Tab Control. The tabs consist of multiple fields from different tables relating to the Employee, like evaluation data, contact info, personal info, and more.
I got the Combo Box in the Header able to search for Records by ID and another one searches by Name. Happy with the auto populating of all the fields on each tab. (Would like to know how to do that in a Navigation form though?)
But, this is my problem. When I created a button to open a add a new record, the form fields saves to the corresponding field in the tables just fine. HOWEVER, If I try to pull the record using the a Combo Box on a
"Different" form, it will not populate the fields. I can see the ID and name in the dropdown in the combo box, but when I select it, I get nothing. weird.
This is escpecially frustrating because I originally wanted users to add new record by using a Different form. I created the form just fine, the form added the record to the tables, but when I went back to the Personnel Form, I could not pull the info into the fields. I could see them in the Combo Drop Box, but it wouldn't populate.
Where is the disconnect?
Building an HR Data Base using EmployeeID as the Primary Key. I have a Personnel Form with a Tab Control. The tabs consist of multiple fields from different tables relating to the Employee, like evaluation data, contact info, personal info, and more.
I got the Combo Box in the Header able to search for Records by ID and another one searches by Name. Happy with the auto populating of all the fields on each tab. (Would like to know how to do that in a Navigation form though?)
But, this is my problem. When I created a button to open a add a new record, the form fields saves to the corresponding field in the tables just fine. HOWEVER, If I try to pull the record using the a Combo Box on a
"Different" form, it will not populate the fields. I can see the ID and name in the dropdown in the combo box, but when I select it, I get nothing. weird.
This is escpecially frustrating because I originally wanted users to add new record by using a Different form. I created the form just fine, the form added the record to the tables, but when I went back to the Personnel Form, I could not pull the info into the fields. I could see them in the Combo Drop Box, but it wouldn't populate.
Where is the disconnect?
