Select transactions before "a certain date" by using a form

  • Thread starter Thread starter ali
  • Start date Start date
A

ali

I have a table, filled with everyday transactions.

I have a form, based on the table mentioned above.


I'd like to:

1) When user input the date into a textbox, i'd like to retrieve all
transaction before (or after) the date input by the user.

2) Is that possible to use a calendar to do so ?




Dear experts, thanks a lot !



-
 
Use the AfterUpdate event procedure of the text box where the user enters
this date, to apply a Filter to the form.

You may also need a combo (or option group) beside the text box so the user
can choose whether they want before or after that date.

It is possible to use a calendar for this.
 

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

Problem Using Dates in a Query 6
Showing value based on another value in a form 3
How to setup database to make transactions (transfers) between two bank accounts 0
Date from form into Append 2
Adding a Username to a Transaction from a Form 1
SubTotals on Forms 7
create a subform without using the wizard 2
Need to automaticallu input date in form 3

Back
Top