Query criteria from form entry

  • Thread starter Thread starter AHassan
  • Start date Start date
A

AHassan

Hey guys im trying to make a query that takes its search criteria from a form
entry... I found out from a friend that i should write in the criteria
section in the query : [Forms]![formname].[feildname] and it worked on his
program but not mine...why?
 
AHassan,

It is not clear what exactly you mean by it didn't work. But I guess
the first thing to check is that you have correctly spelled the name of
the form and the name of the control. And that the form is open at the
time.

In this context you would more often see a "!" rather than a "." used,
as in:
[Forms]![formname]![fieldname]
 
Back
Top