Passing date via form to passthrough query

[dtoney]

I have a passthrough query where I have to manually edit the dates for the
information I need. I would like to utilze a form & enter the start & end
dates there & allow the SQL to be updated via the form.

Please advise how best to do this.

Thanks!

 

[Bob Barrows [MVP]]

I have a passthrough query where I have to manually edit the dates
for the information I need. I would like to utilze a form & enter the
start & end dates there & allow the SQL to be updated via the form.

Please advise how best to do this.

You will need to use VBA to modify the Sql property of the querydef object.
There are examples in online help (if you can find them - use the table of
contents and expand the Programming with VB section) as well as plenty to be
found via a google search.