Help with a query!

[law]

Hello,

Can anyone help me with a query which I need to set up. I have a user login form & when the user enters their username,password & staffNumber into the textboex & they click ok I would like it to display only their details for example staff number 1. I would like it to display all the details in the table with relating to staff number 1 only.

I can set it up with a query but I need to do it in VBA code & arent to sure about that, can anybody help?

 

[Pat Hartman]

I'm not sure where you're going with this but you can read a query in code using either DAO or ADO. Look up OpenRecordset in help.