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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use In() Expression as Query criteria with guts from Function 1
Like "* " and function to pass parameters into a query 4
Passing Function values to a Query 6
Passing Form Values to Queries 3
First function returning min 4
Passing Variables to a query 2
Pass Through Query - not returning rows 1
Access Invalid bracketing of parameter name 1

Back
Top