Bound form with subform pops up parameter box

[vegathena]

I have a bound form that is used to enter the information of the
child. This form has a subform used to enter the information of the
mother. Each of these forms has its own table for record source. The
link child and master fields are the id's (which are the same) in the
respective tables (which have a one-to-one relationship).
Also, the following goes for both master and subform:
Allow Filters: yes
Allow Edits: no
Allow Additions: yes
Data Entry: no
Recordset Type: Dynaset

I only need these forms for data entry. They won't be used to display
any existing records.

The problem now is that when I switch from design view to form view, I
am asked to enter parameter values for the child and the mother (the
master and the subform). I didn't set those up those parameter boxes.
How do I get rid of those? And how to get the form and subform to
display blank so that new records can be entered?

I need to have the info of child and mother entered on the "same" (to
the user) form. Your help and advise are appreciated!

 

[Ken Snell \(MVP\)]

Check spellings of the names you put in the LinkChildFields and the
LinkMasterFields properties; be sure they are correct. Also, be sure that
those fields are in the appropriate recordsources for the main form and the
subform.

 

[vegathena]

Thanks, Ken. I checked those and they are correct.
Also, the subform displays completely blank when viewing the main form
in design mode.
Any other suggestions?

Is it even possible to use a main form and subform solely for data
entry? How to get the subform to display properly, i.e. not as a white
box (both design and form view), when it has no records to display?

Thanks.

 

[Ken Snell \(MVP\)]

Be sure that the query that is the subform's recordsource is updatable, and
be sure that AllowAdditions and AllowEdits properties for the main form and
the subform are set to Yes. Also be sure that there is a SourceObject listed
for the subform control on the main form.