Passing date via form to passthrough query

  • Thread starter Thread starter dtoney
  • Start date Start date
D

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!
 
dtoney said:
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.
Click to expand...
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.
 
Back
Top