K
Kerry Purdy
Hi
I have a Main Switchboard form with 2 unbound fields
StartDateEntry = Date Picker controlled - user will always choose a Monday
EndDateEntry = Date chosen in StartDateEntry + 4 days
I have a query looking for bookings made between these dates. Originally I
typed the criteria
Between [Forms]![Frm Main SB]![StartDateEntry] And [Forms]![Frm Main
SB]![EndDateEntry]
but have now noticed that the answers are missing data.
I noticed that mondays are never included, Tues, Wed etc. work fine but it
never shows the date in the date picker field only the Tuesday to Friday
(EndDateEntry)
If I use the Build wizard EndDateEntry is recognised as a field on the Main
Form but StartDateEntry is not showing.
I have checked and accounted for every object on my main form, command
buttons, images, boxes and labels the field for StartDateEntry is nowhere to
be found.
Its driving me crazy - can anyone help please?
Thanks very much for your time.
Kerry
I have a Main Switchboard form with 2 unbound fields
StartDateEntry = Date Picker controlled - user will always choose a Monday
EndDateEntry = Date chosen in StartDateEntry + 4 days
I have a query looking for bookings made between these dates. Originally I
typed the criteria
Between [Forms]![Frm Main SB]![StartDateEntry] And [Forms]![Frm Main
SB]![EndDateEntry]
but have now noticed that the answers are missing data.
I noticed that mondays are never included, Tues, Wed etc. work fine but it
never shows the date in the date picker field only the Tuesday to Friday
(EndDateEntry)
If I use the Build wizard EndDateEntry is recognised as a field on the Main
Form but StartDateEntry is not showing.
I have checked and accounted for every object on my main form, command
buttons, images, boxes and labels the field for StartDateEntry is nowhere to
be found.
Its driving me crazy - can anyone help please?
Thanks very much for your time.
Kerry