Carrying values over in forms to queries

[pwd]

I'm trying to have a form where once you enter in one field, say, name, it uses that name as a part of a where statment. For example:

SELECT [Products bought]
FROM [Sales Database]
WHERE [Name] = [The name you entered in the last field of the form]

From here that Product pull down menu lets you select the item which the customer bought. It only display the products associated with that customer you entered in the name for.

Thanks,

Eric Madej

[KnooKie]

Originally posted by pwd
I'm trying to have a form where once you enter in one field, say, name, it uses that name as a part of a where statment. For example:

SELECT [Products bought]
FROM [Sales Database]
WHERE [Name] = [The name you entered in the last field of the form]

From here that Product pull down menu lets you select the item which the customer bought. It only display the products associated with that customer you entered in the name for.

Thanks,

Eric Madej

something like........

SELECT [Products bought]
FROM [Sales Database]
WHERE [Name] = [Forms]![MyFormName]![MyFieldName]