Thank you for the sample. I had figured out that I was going about it the wrong way. I should have just made the clientId an Autonumber and updated the table when I created a new Client with the emplyeeID.
Thank you again,...
User Profile
Collapse
-
VBA CreatingNewClientAlsoloogingIn
I am creating a login for emplyees but when they click a button I also need it to grab the next ClientID in a table called tblReferral.
Tables
tblReferral
Forms
frmChoose
Currently I am getting the name from a form called frmChoose it is the same form with the button to be clicked. So I will grab the name from the unbound form and then run a query to grab the max ClientID in tblReferral,Bot h parts...
No activity results to display
Show More
Leave a comment: