Subform Error Message Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a simple form with a subform reflecting a one-to-many relationship.
When I try to add new records to the main table using the main form or to
the "many" table using subform I get the following message:

"The LinkMasterFields property setting has produced an error: The object
doesn't contain the automation object 'tbl'main file name.'" (The Help
button brings up information on ApplyFilter Action.)

Note, however, 1) the records do get added in spite of the error message,
and 2) there are no problems with the update when I make them in the table
view.

What basic concept am I missing here???
 
Did you skip using the subform wizard perhaps? Open your main form in
design mode; single-click your subform to view properties and check the
"link child fields" and "link master fields". These should be the name of
the control sources on your main form and subform that are bound to the
primary and foreign keys of your data source. If you click to the right of
these properties, then on the ellipses symbol, a dialog will help you
build/edit these relationships.
-Ed
 
Ed, Thanks for the quick response. I did use the wizard to create the
subform. I checked my subform properties per your suggestion and the
linkages are right. I'm sure I'm doing something so basically stupid that no
one would think anybody could be that dumb.

All I am trying to do is develop a little demo to show someone (even more
novice than I am) how to relate a table of keywords (the many) to an event
table (the one) and to use the main form with its subform to add both events
and keywords for the event.

Peg
 
Back
Top