Query criteria from form entry

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?
 
S

Steve Schapel

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top