opening form on a condition

[przystal]

hi
im new in access and vba and my question is this:

i have a db and ive created form where you must put name and lastname and id like that when some user do it on vba will check name and lastname and on base of that itll open appropriate other form.
lets say db starts and shows form with fields to write name and hes doing it (let say he wrote mr. smith) after doing it user presses 'process' button and on base of what name and lastname he entered (mr. smith) appropriate form is being opened. and the name that user has entered is not in vb script it shws error message and returns to the begining

is it possible?
and can someone help me with this?

many thanks,

przystal.

 

[MaximusArcher]

Yes it's possible and there are endless ways of doing what you describe.

One solution would be to have a users table containing name and surname and any other relevant information, in your case, the name of a form.

Create a login form to query the user details when they enter them, if they match, open the associated form that matches the users name.