autofill of check boxes not working on first new record

P

p-rat

I have a form with two unbound items. frame (check boxes) and text
box.

frame is for shift and textbox is for date

I have another form (data entry form) that has the same two fields and
these get autofilled by setting the Default Value = unbound fields on
first form.

the second form as described is a data entry form. when opened and the
form is showing it's first new record the date is autofilled, but not
the check box. when moving to the next new record the check box will
autofill and so will the date and it looks fine.

why does the date autofill on the first new record, but not the check
box? i have no clue and any help would be greatly appreciated. thanks.
 
P

PJFry

It sounds like you are working with an Option Group.

Instead of setting a default value for the option group on the second form,
set the value for the option group on the OnLoad event for the second form.

(On the second form)
Private Sub Form_Load()

Me.NameOfFrameOnSecondForm = Forms!NameOfFirstFormHere!NameOfFrameOnFirstForm

End Sub


You can do the same thing for the date if you wish.

PJ
 

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