day of week - help

[Kroghr]

I have a field named FlightDate on a form. The field is formatted for short date. I also have 6 unbound text boxes names KWACO1, KWACO2, KWACO3 etc etc
I need a code that determines if Me.FlightDate is a Tuesday, then Me.KWACO1 = 0600, Me.KWACO2 = 0710, Me.KWACO3 = 1430
Wednesday, then Me.KWACO1 = 0600, Me.KWACO2 = 0710, Me.KWACO3 = 1430
I've tried formating the FlightDate as DDDD to determine the day of the week for the date selected and then used a if then statement, but it does not work.

Any advice would be greatly appreciated

 

[ajetrumpet]

i'm sure you know how to write IF statements, so use the weekday() function on the text box to get your determination:

if weekday(me.flightdate) = 3 OR weekday(me.flightdate) = 4 then

etc..