Continuous Subform Problem

J

Joe

Hi,

I am building a timesheet form with a timesheet detail
subform. I have a parent child relationship established between
tblTimesheet and tblTimesheetDetails with TimesheetID being the
primary key and the LinkChildFields and LinkMasterFields property of
my subform both set to TimesheetID. My parent form is in normal form
view and my subform is in Continous view.

So everything appears to be set up OK, but at runtime, when I
put the form into New mode, ready to accept a new timesheet, the
subform is not blank, it displays data that already exists in
tblTimesheetDetails. Since the parent form does not have a
TimesheetID established yet, the subform should not be displaying any
data.

The weird thing is that when I switch my subform to Datasheet
view, the problem goes away and it behaves like I would expect a form
to behave when it is awaiting entry of new data. But the problem
appears when I am in Continous view. I need to be in Continuous view
for other reasons.

Does anyone know how I can get the subform to behave correctly
and not display any data when it is in 'New' mode awaiting the entry
of a new timesheet?
 

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