Combo selection

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

Guest

I (still) have a combo with a few columns. The bound column is a date.
Is it possible to code the combo so that all the records are displayed but
only dates >Date() are selectable - maybe some form form of OnClick exclusion

Driving me mad

I can't simply run the combo from a query with >Date() as the criteria as
this would remove all the items from the combo that were from before today -
and I need to be able to view these (but stop a bunch of mad users selecting
them)

Any help would be great
 
I (still) have a combo with a few columns. The bound column is a date.
Is it possible to code the combo so that all the records are displayed but
only dates >Date() are selectable - maybe some form form of OnClick exclusion

Driving me mad

I can't simply run the combo from a query with >Date() as the criteria as
this would remove all the items from the combo that were from before today -
and I need to be able to view these (but stop a bunch of mad users selecting
them)

Any help would be great
Click to expand...

You could code the control's BeforeUpdate event:
If Me!ComboName <= Date Then
MsgBox "You must select a future date."
Cancel = true
End If
 
Thanks Fredg

I tried that but as the form is actually used on shop counter tops by sales
assistants (not that there is any thing wrong with sales assistants) and they
tend to just tap away at the screen and not read it. I even tried turning
the screen bright red if they selected a past date - nothing they just
carried on.

Maybe it's not possible - if it's not I will simply have to add another
combo with criteria and make the 1st read only. BUT as the screens are only
around 5inch square I really don't want to add anything thats not absolutely
essential.
 
Back
Top