Combo box for data entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with several fields, some of which are prepopulated. I want to
be able to use a drop down box to select the date, and then get all records
with that date, and only those records with that date, to perform data entry.
How do I make the form stop after the last record for a date, or conversely,
go to the next date after the last record with the original date?
 
Hi,

You can use a filter, on the form, to limit the records to be displayed.
Through code, the syntax is:


Me.Filter="FieldDateTimeName=" & Format( wantedDate , "\#mm-dd-yyyy\#")
Me.FilterOn = True


As far as detecting if you are moving past the last record, you are
generally in a mode of adding a new record, so something may be done there?
Also try to imagine a way to get out of this "mode". To remove a filter,
through code, try


Me.FilterOn=False






Hoping it may help,
Vanderghast, Access MVP
 
Back
Top