A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Bound form with subform pops up parameter box



 
 
Thread Tools Display Modes
  #1  
Old April 21st, 2008, 09:23 PM posted to microsoft.public.access.forms
[email protected]
external usenet poster
 
Posts: 28
Default 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  
Old April 22nd, 2008, 02:44 AM posted to microsoft.public.access.forms
Ken Snell \(MVP\)
external usenet poster
 
Posts: 2,506
Default 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  
Old April 22nd, 2008, 02:46 PM posted to microsoft.public.access.forms
[email protected]
external usenet poster
 
Posts: 28
Default 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  
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!




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:14 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.