Pass Function Return to Query

  • Thread starter Thread starter Pat G
  • Start date Start date
P

Pat G

Hi,

I have a query that asks the user for a date to be
entered. This date is used to restrict the query results.

I have a function that pops up a calandar allowing the
user to pick a date.

I konw how to use the function in a form but have do I
get the query to run the function?

How do I pass the calandars pick to the queries variable?
 
Hi,


Use a function in a standard module that opens the form to get the date, and
let that function returns the selected date. In the query, use that
function.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top