Re: Combo box for data entry
From: Michel Walsh (vanderghast_at_VirusAreFunnierThanSpam)
Date: 12/10/04
- Next message: Michel Walsh: "Re: events seem to invoke error message User-defined type not defi"
- Previous message: Michel Walsh: "Re: query results into string?"
- In reply to: cursednomore: "Combo box for data entry"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 10 Dec 2004 07:26:29 -0500
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
"cursednomore" <cursednomore@discussions.microsoft.com> wrote in message
news:A7B85D8D-D63A-446C-8349-2F880DD33398@microsoft.com...
>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?
- Next message: Michel Walsh: "Re: events seem to invoke error message User-defined type not defi"
- Previous message: Michel Walsh: "Re: query results into string?"
- In reply to: cursednomore: "Combo box for data entry"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
