How to pass a variable from form to query?

[marks416]

Hi

I have a query like

select * from table1 where column1 = "?"

I need pass the ? variale from a form .

Please let me know how to do that?

I also like show the query result on a report.I need a simple tutoral to know this.

Do you have a URL link for this?

Thanks for help

M

 

[RivetHed]

Set your criteria to [forms]![FormName]![ControlName]

as far as reports go you can get ok results just using the wizard.

 

[SeeThru]

if your column1 is a stribg, you need:

"select * from table1 where column1 = '" & [forms]![FormName]![ControlName] & "'"

The singe quotes enclose the string value. If it is numeric, you need:

"select * from table1 where column1 = " & [forms]![FormName]![ControlName]

with no quotes.

Dates are even more fun!