VBA CreatingNewClientAlsoloogingIn

[Rob81473]

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 of this the unbound form Name and the Max client ID will then be saved into the table tblReferral.

I hope I did not confuse everyone.

[robjens]

So everything works as expected? The way you are doing it is imho the best for beginner/average Access experience. But then again, learning recordssets is easily done and very very rewarding so...DAO all the way.

[Jim Doherty]

Hello,
first time doing this. 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 of this the unbound form Name and the Max client ID will then be saved into the table tblReferral.

I hope I did not confuse everyone.

Yes pitching your sophistication depends on how comfortable you are with it.

For your benefit and in addition to Robjens comments I have knocked together and attached a little database for you to chew over the different methods to enable you to consider some options. Its not the definitive article but its a start hope it helps you.


Welcome to Byes :)

[Rob81473]

Yes pitching your sophistication depends on how comfortable you are with it.

For your benefit and in addition to Robjens comments I have knocked together and attached a little database for you to chew over the different methods to enable you to consider some options. Its not the definitive article but its a start hope it helps you.


Welcome to Byes :)

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,