View Single Post
  #4  
Old April 27th, 2008, 08:14 PM posted to microsoft.public.access.forms
Ken Snell \(MVP\)
external usenet poster
 
Posts: 2,506
Default Bound form with subform pops up parameter box

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.

--

Ken Snell
MS ACCESS MVP


wrote in message
...
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.



On Apr 21, 9:44 pm, "Ken Snell \(MVP\)"
wrote:
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.

--

Ken Snell
MS ACCESS MVP

wrote in message

...

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!