Subforms

[Secret Squirrel]

I have a main form with 2 subforms that I use to track members. On the main
form I have just the date. On one subform (frmDailyDetail) I have fields
where the members are logged in for that day. On my other subform
(frmGuestDetail) I have fields where the user can enter guests for that
member. I have the frmDailyDetail linked to the main form. On the
frmGuestDetail I have it linked to frmDailyDetail by the RecordID of the
tblDailyDetail. The problem I'm having is when I enter new information on the
frmDailyDetail and then go to add guests for that record to the
frmGuestDetail it won't allow me enter anything. It won't let me create a new
record on the frmGuestDetail. Any ideas why this is? I hope I explained it
good enough.

 

[magmike]

I have a main form with 2 subforms that I use to track members. On the main
form I have just the date. On one subform (frmDailyDetail) I have fields
where the members are logged in for that day. On my other subform
(frmGuestDetail) I have fields where the user can enter guests for that
member. I have the frmDailyDetail linked to the main form. On the
frmGuestDetail I have it linked to frmDailyDetail by the RecordID of the
tblDailyDetail. The problem I'm having is when I enter new information onthe
frmDailyDetail and then go to add guests for that record to the
frmGuestDetail it won't allow me enter anything. It won't let me create anew
record on the frmGuestDetail. Any ideas why this is? I hope I explained it
good enough.

I'm not certain this will remedy your situation, but I had that same
issue when entering a new record and then wanting to add data to
related tables whether in a subform on the same form or a second one
that pops up. I think what you need to do is refresh the form first in
your button's onclick before running the openform command, or if in
subform on same form, then refresh first on lost focus of the main
form and/or on gotfocus of subform.