D
Dale
I have a form with several subforms in it. The way this form currently works
is that the main form is where someone will select a client and then enter a
date. Just below are 24 questions with Yes, No, NA checkboxes. When someone
selects a Yes, No, NA response it triggers the ondirty event which uses the
code:
If Me.NewRecord Then
Me!kDate = Me.Parent!Txt64
End If
This works fine but now I want it so that the Yes responses are set on by
Default, which I have done in the response table itself by setting the
default to 1 to represent yes. The problem is now it will not populate the
date. I then tried to add to the main form a link to another table that the
date is stored which they will type in before they go into the form and then
I figured out the MasterLinkform field and Childlinkform field which will
allow the date to default to whatever is in the date table. This appeared to
work because when you open the form it shows all Yes responses marked and the
date in the main form is the date is defaulted in each date field of the
subforms. The problem is, the data is not saved. In otherwords, unless i go
back and click on one of the actual responses other then Yes, it doesn't save
anything when I close the form. I even tried to create a macro that is set to
gotocontrol and go to each subform control and change the OnDirty to be
OnFocus and you click on a button that runs the macro but that does not seem
to work either. What can I do to make it save the defaulted information to
the table?
is that the main form is where someone will select a client and then enter a
date. Just below are 24 questions with Yes, No, NA checkboxes. When someone
selects a Yes, No, NA response it triggers the ondirty event which uses the
code:
If Me.NewRecord Then
Me!kDate = Me.Parent!Txt64
End If
This works fine but now I want it so that the Yes responses are set on by
Default, which I have done in the response table itself by setting the
default to 1 to represent yes. The problem is now it will not populate the
date. I then tried to add to the main form a link to another table that the
date is stored which they will type in before they go into the form and then
I figured out the MasterLinkform field and Childlinkform field which will
allow the date to default to whatever is in the date table. This appeared to
work because when you open the form it shows all Yes responses marked and the
date in the main form is the date is defaulted in each date field of the
subforms. The problem is, the data is not saved. In otherwords, unless i go
back and click on one of the actual responses other then Yes, it doesn't save
anything when I close the form. I even tried to create a macro that is set to
gotocontrol and go to each subform control and change the OnDirty to be
OnFocus and you click on a button that runs the macro but that does not seem
to work either. What can I do to make it save the defaulted information to
the table?