query for current record

[Guest_imported]

Hi,

I need some help on a query that I'm working on.

I have a query that will populate a list box but right now it shows every thing in the table. I need it to show only those data itme where the Computer_Name is equal to the current records computer name. Is this possible?

thanks

 

[GingerR]

in the query grid bring down the field Computer_Name if it isn't there already. underneath in Criteria right-click and choose BUILD and browse to Forms then the name of the form then the name of the field you want it to be equal to. should look something like:

forms!FormName!Computer_Name

where FormName = the name of your form and
Computer_Name i'm assuming is the name of the text box on the form.

g