set date to certain day

[plgii]

I have an ActiveX calendar popup but need to limit user choice to Friday only so if they choose other day it prompts them to ONLY choose a Friday, or how can I populate date field to Friday only based from other date field?

 

[Matt Greatorex]

In the form's Before Update event you could add a check to see if the selected date is correct. e.g.

If Format([Forms]![[I]form name[/I]]![[I]date field[/I]],"DDDD") <> "Friday" Then
     Msgbox "You must pick a Friday"
End if