Set Date via popup form?

D

Dave Elliott

I have a form named frmSetpaydate that I want to use to set the date on a
sub-form on my main form.
I have command buttons on the popup form for the days of the week, i.e.
Thursday Thru Wednesday
There names and caption names are respective to the days of the week, i.e
Thursday is caption and name
Cant get the below code to set the date on my form when code is triggered,
why?

Forms![TimeCards]![Time and Hours].Form![WorkDate] = Thursday.Value
Forms!TimeCards![Time and Hours].Form!Hours.SetFocus
DoCmd.Close acForm, "frmSetpaydate"
 
G

Guest

If the control 'Thursday' is a command button, it won't have a property
called Value. Try
Forms![TimeCards]![Time and Hours].Form![WorkDate] = Thursday.Caption

Hope This Helps
Gerald Stanley MCSD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top