Pass Function Return to Query

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

Michel Walsh

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
 
Top