Query based on actual record

[manicminer]

Hello everybody, I have a specific problem. I have a table with names (first and last) and other data. And I need a query which will show only the rows containing specific first names (e.g.all rows with names "John"). The value (in this case the first name), should be selected from the currently selected record (the user chooses a record using a form an then generates a query which will contain all the records containing the first name from his currently selected record.


I never made a db in access before, so maybe my question is trivial. But if anybody knows how to solve this will help me immensely.

[orange]

I do not follow your request but to find all records in MyTable with FirstName = "John"

Select *
From MyTable
WHERE
FirstName = "John";

[manicminer]

OK, but I would need something like FirstName=firstname_from_currently_opened_record. Not a predefined "john"

[June7]

The record is open on a form then the query can refer to control on form as input parameter, like:

SELECT * FROM MyTable WHERE FirstName = Forms!formname!textboxname

[manicminer]

Thanks a lot June7!!!!!! As a complete beginner, it took me some time to figure it out (practically no knowledge of SQL), but it works. Thanks again ! :-)