adammitchell23
Registered User.
- Local time
- Today, 09:29
- Joined
- Oct 30, 2017
- Messages
- 24
Hi all,
I need to enter a value into an unbound text box on a form (frmCaptures) from a table (tblSeason).
tblSeason specifies a SeasonID (eg. "2017-2018") and the start and end dates for that season (e.g. the 2017-2018 season starts in June 1, 2017 and ends May 30, 2018).
I need users to be able to enter a single capture date in frmCaptures and then the unbound text box on the form to be populated with the SeasonID from tblSeason where the date they entered falls between the dates for that season using the AfterUpdate event).
So, if users enter a capture date as June 2, 2017, the text box populates with "2017-2018".
It seems I should be looking at using DLookup for this, but despite searching I still don't know how.
Thanks,
Ad
I need to enter a value into an unbound text box on a form (frmCaptures) from a table (tblSeason).
tblSeason specifies a SeasonID (eg. "2017-2018") and the start and end dates for that season (e.g. the 2017-2018 season starts in June 1, 2017 and ends May 30, 2018).
I need users to be able to enter a single capture date in frmCaptures and then the unbound text box on the form to be populated with the SeasonID from tblSeason where the date they entered falls between the dates for that season using the AfterUpdate event).
So, if users enter a capture date as June 2, 2017, the text box populates with "2017-2018".
It seems I should be looking at using DLookup for this, but despite searching I still don't know how.
Thanks,
Ad