Condition Macro

[Faris_dxb]

Hi, I need help with Access. Could you please help me with creatio
Search Form. I’m trying to create search Form, I want when the I ente
the number in the field then click on search, other form open with th
result which read from query. I think there should be link between th
search form and result form, which read from query (condition macro).
need explanation with creation these form and what should be the lin
and who to create condition macro for this issue.

Thanks.
Faris_dx

 

[Steve Schapel]

Faris,

No, this is not really a job for a macro. If I understand you
correctly, you need to put in the criteria of the query that the second
form is based on, a reference to the control on the first form where you
entered the number for selection. For this, you use syntax equivalent to...
[Forms]![NameOfFirstForm]![NameOfCriteriaControl]

 

[Faris_dxb]

Thanks for replies. I will try it

 

[Faris_dxb]

Thanks for replies. I will try it

 

[Faris_dxb]

Thanks for replies. I will try it