Display Date Criteria on Form - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Display Date Criteria on Form

Robert Sena

4 years ago

Is there any way to display the date criterial on a form based on a query? I was able to make it work on a report but am having some issues getting the dates to display on a form. [StartDate] and [EndDate]
Thanks

	Alex Hedley @Reply 4 years ago
Aren't you taking the criteria from textbox(es) on the Form to pass to the Query? Otherwise it's just hard coded.

	Robert Sena OP @Reply 4 years ago
I was entering the date parameters upon opening the form but if I can open the form then set my parameters that will work better, and the textboxes will show the criteria I need. Thanks Alex.

	Alex Hedley @Reply 4 years ago
Value From a Form

	Robert Sena OP @Reply 4 years ago
Need Help How I would go about getting the parameters [FromDate] to [ToDate], from a query, to display on a form. I do know how to get the parameters to display on my report. Thanks

	Alex Hedley @Reply 4 years ago
@Robert I've moved your above post to this thread, instead of a new question.

	Alex Hedley @Reply 4 years ago
Are you currently doing this? Query Criteria

	Robert Sena OP @Reply 4 years ago
Yes. The query is working. I need the query parameter dates on a form so I can upload the dates to a table for permanent record.

	Scott Axton @Reply 4 years ago
Your best bet then is to create an intermediate form to gather the date info. Then you can both store the dates and use them in your query. That is demonstrated in the Value From a Form video Alex linked above.

	Robert Sena OP @Reply 4 years ago
Ok got it to work. Everything goes to the form..I used the following syntax. Is there any way to stop the query from popping up? The values are populating on the form like I want them to. Thanks. `Private Sub RunQueryBtn_Click() DoCmd.OpenQuery "PayEstimateSummaryQ", acViewNormal End Sub`

	Alex Hedley @Reply 4 years ago
Did you swap the Query criteria to take the values from the Form?

	Robert Sena OP @Reply 4 years ago
I did not. How would I do that? That would really come in handy.

	Robert Sena OP @Reply 4 years ago

	Robert Sena OP @Reply 4 years ago
Picture of how I tied query to form uploaded

	Alex Hedley @Reply 4 years ago
Why aren't you setting the output of the query a continuous detail of the Form With your criteria in the Form header?

	Robert Sena OP @Reply 4 years ago
I'm still new at this and learning quick. Now that you have suggested it, I can research it so I can build it as you described.

	Robert Sena OP @Reply 4 years ago
I used requery VBA syntax. Works. Thanks Alex

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View