Making a identifications form

[Larshg]

Hi - I want to make a form where the user chooses his/her Id, and then moves on to the form, that has information that are relevant to them. There are to forms that they can move on to and there are 6 users.

I have build am If sentence that opens one of the to forms, what I don't know is how I make a comparison between a user and a query that may or may not have him.

I an thinking of using a SQL sentence that looks in a query to see if the Id is in the table and returns 'true'

 

[HenryAnthony]

Larshg,

I'm trying to do the same thing and found the answer in the Access sample file "Developer Solutions". Something about "Display results on a form based on selection of value in combo box".

It is a better explanation than I could post here.

Best regards,

Henr¥

 

[Larshg]

I am not sure that that is what I want to do, and I can't fond the referred sample file.

What I want to do is create a login for that directs the user to the form that belongs to him.

 

[Cagliostro]

You can do query with parameter from a form
select* from table where WhatYouLookFor = yourForm.yourParameterFromYourForm. If you run this query when your form is open you will get good results. John Fill

 

[therayster]

Here's my 2 cents... Why have the users select their ID? Secure the database, force them to login, then use CurrentUser() as a parameter. Any query that returns EOF doesn't pertain to that user, so display a message telling the user so. If you get rows then the user has at least one row that applies to them.