Allen Browne Calendar

[Bob Vance]

My code for your calendar is getting an error "A syntax error"

Private Sub cmdcalendar_Click()
=CalendarFor([tbDayNo], "Select the sale date")

End Sub

 

[Allen Browne]

The idea was to set the On Click property (in the Properties sheet) to:
=CalendarFor([tbDayNo], "Select the sale date")

If you want to use code in the event procedure, try:
Call CalendarFor([tbDayNo], "Select the sale date")

 

[sajdh]

abcdefghijklmnopqrstuvwxyz

The idea was to set the On Click property (in the Properties sheet) to:
=CalendarFor([tbDayNo], "Select the sale date")

If you want to use code in the event procedure, try:
Call CalendarFor([tbDayNo], "Select the sale date")

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

My code for your calendar is getting an error "A syntax error"

Private Sub cmdcalendar_Click()
=CalendarFor([tbDayNo], "Select the sale date")

End Sub