Hi
Here is the Db with the Form Bound to the Table
Hi
Here is the Db with the Form Bound to the Table
Hi - thank you for spending your time to do this.
When i manually input the manager, hiredate, startingpay, hours - how do I then save that back to the table? (tblUserSocialInfo)
Hi
I have added a Command Button to Save and Close the Form
Hi - i get this error. I think you are trying to save back to tblImport1 when I want to save everything but the name to tblUserSocialInfo
Hi
Sorry Try this version
We are getting closer!!!!
Where is the default data coming from?
I only want id and user to be pulled from tblImport1
The fields manager, hiredate, startingpay, and hours should be coming from tblUserSocialInfo
Meaning - if the data for the UserID does not exist in tblUserSocialInfo then the form should load with empty values for manager, hiredate, startingpay, and hours
If the userID does exist in tblUserSocialInfo then the values from that table should load for manager, hiredate, startingpay, and hours
Hi
The example I have given is how to Bind a Form to a Table.
As you have not as yet given an explanation of what you are trying to achieve then I can't give an guidance.
Is tblImport1 a one off Import of data just to list Current Users?
A more detailed explanation of your process would help everyone.
I need to be able to get a list of users and userID (tblImport1) for the end user to select from, and input the other fields manager, hiredate, startingpay, and hours
That's the difficulty i keep running into is that i am trying to load data from one table, and save/load data from a second table as well.
My brain hurts working on thsi.
Hi
The example I have given you allows you to select a User from tblImport1
It also allows you to select a Manangers Name from tblManagers.
Can you tell us whether the fields HireDate, StartingPay and Hours relate to the User or the Manager??