query criteria 1

[pertotal]

hi all,

I have a problem with the syntax in a query :

I have a form X with a subform Y,
in the subform Y I have a PO_number which should be used as a criteria in the query.

How is the syntax [forms]![Y]![po_number] ????

thnx in advance

 

[K9Boxer]

I have tried to supply your values in the statement....

Forms![X]![Y].Form![PO_Number]

An easy way to get this information:
In query design
Right Click on Criteria
Select Build
Select Forms
Select Loaded Forms (have your form open)
Select Main Form (+) in the folder
Select Sub Form
Select Control from next column
Paste - there is your correct syntax.

I quite often forget the correct syntax. This is an easy was to get it.

 

[mailzero28]

Try syntax as follows:

[Forms]![X]![Y]![po_number]

This should be the correct location of the po_number for a criteria in a query.

bye

Martin.