Subform for data entry only

[Jay Oken]

I have a form with a tab object with two pages. On each page I have a
different subform both of which point to the same table. When the main form
opens I would like one of the subforms to open in data entry mode to a blank
record. How do I do this.

Thanks,
J

 

[Dirk Goldgar]

I have a form with a tab object with two pages. On each page I have a
different subform both of which point to the same table. When the main form
opens I would like one of the subforms to open in data entry mode to a
blank record. How do I do this.

Hi, Jay!

Did you try setting the Data Entry property of that subform's source-object
form to Yes? I can't help feeling this must be more complicated than that.
Are you using the same subform in more than one place, so that you don't
want to set that property at design time?

 

[Jay Oken]

Yes the Data Entry property is set to yes and it is a different subform. The
subform defaults to data entry mode but it picks up the first record listed
on the second subform (which is tied to the same Volunteer table ;-))

 

[Dirk Goldgar]

Yes the Data Entry property is set to yes and it is a different subform.
The subform defaults to data entry mode but it picks up the first record
listed on the second subform (which is tied to the same Volunteer table
;-))

I'm not sure what you mean by "picks up the first record listed on the
second subform". If the subform is in Data Entry mode, it should open to a
blank record. Does it not do that? Where/when does this "picking up"
occur?

Are both subforms based directly on the Volunteer table, or do they have
queries (possibly the same, possibly different) as their recordsources?
What are the Link Master/Child fields of the subforms?

 

[Dirk Goldgar]

To whom it may concern -

This problem was taken offline with the OP. The problem appears to be due
to a bug in Access, resetting the subform's DataEntry property. Further
investigation into the bug is required, though. In the mean time, we
arrived at a successful workaround: setting the subform's RecordSource to a
query that returns an empty recordset.