Specific Date for Select Case

[todgers]

OK I have done a select case as follows

Private Sub Form_Current()

Select Case DatePart("w", Tape_Date)
    Case 1, 3, 5

Clearly this runs/works on a Sunday, Tuesday and Thursday.

I have tried to adjust this to work on a specific date but I'm struggling.

Would I use 'datePart' or just 'Date' and what format in the case would I use.

Thanks in advance

 

[KenHigg]

You mean something like:

Select Case Tape_Date
Case 4/3/2006

???

 

[todgers]

Sorry tried that but it does not work.

Tape_date is the name of the date field on this form and I'm trying to make a combo box called 'Tape' visible on that specific date?

 

[KenHigg]

You may have to pound the date:

Case #4/3/2006#

???

 

[todgers]

Ken, I owe you a pint, thanks very much

 

[KenHigg]

Ken, I owe you a pint, thanks very much

Cool -

Still, something tells me it's bad juju to hard code a date param into your code like that - Will you ever need to consider any other date?

 

[todgers]

I will need to add other dates to a different field, why what do you suggest?