Run Query with only one form and table

  • Thread starter Thread starter tom
  • Start date Start date
T

tom

In an effort to reduce the clutter of objects in
my database, I want to design a form with
a control box that holds the date and then
the form will show only invoices with that date.

Is this possible, or are do you need to create one
more object?
 
What you're describing should work.

Once you've selected the date, apply a filter to the form:

Me.Filter = "InvoiceDate = " & Format(SelectedDate, "\#mm\/dd\/yyyy\#")
Me.FilterOn = True
 
You must log in or register to reply here.

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

Access Query to show last entry only 4
Outlook Creating an Outlook form 2
Access How to Validate the query parameter before loading the form that is based on the query iteself? 2
Windwithme COMPUTEX 2025 AI NEXT New Product Highlights 4
Wanting to Update Tables without Affecting Old Records 3
Access Determine what query to run based on a checkbox 0
list box requirements query object/control criteria 1
Choosing a form’s record source 3

Back
Top