Need help in access2

[Puso]

I have a query running where when i click on a button and it has to find the username, password and which menus the user has access to.
My problem is that when i run it only checks the first record in the query and stops there. how do i get it to search through the query record by record until it gets to the username that is = to the textbox.
I am new to access and i am using access2.
Any help will be appreciated.
Puso

 

[Murli]

Enter the following in the criteria section of username field in your query:

=[forms]![formname]![textboxname]

 

[Puso]

Enter the following in the criteria section of username field in your query:

=[forms]![formname]![textboxname]

Thanx Murli, I just tried it and it works like a charm.