If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Bound form with subform pops up parameter box
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! |
#2
|
|||
|
|||
Bound form with subform pops up parameter box
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! |
#3
|
|||
|
|||
Bound form with subform pops up parameter box
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! |
#4
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|