Continous forms and subforms


G

Guest

I was reading and also received the message when trying this that you can't
create a subform within a continous form. I was able to put my subform in the
footer of the continuous form but even though I set the Allow Edits property
to Yes on the subform it doesn't let me add new records. So, I wanted to
verify that in the current and past versions of Access, you just can't have a
continous form that contains a continous subform? I was using the continous
form for allowing users to edit or delete existing records and it allowed for
displaying a "batch" of records at time and they could sort the list and
easily scroll to the record on the screen. I guess my only alternative if I
want to use what is built in is to go to a classic master form/detail sub
form look and have them use the built-in menus to find the record they want
to navigate? I appreciate any thoughts or suggestions on this. Thanks.
 
Ad

Advertisements

J

Joan Wild

You cannot have a continuous form nested within a continuous form, however
you can have adjacent continuous forms on a main form that have a parent
child relationship.

Just add a textbox to the main form with a control source of the first
subform's key field. Then in the link master/child properties for the
second subform, set the master to the name of this textbox
(Forms!firstSubformName.Form!SomeKey) and the child link to the foreign key.
 
G

Guest

Where are is the "link master/child properites" for the second form at? How
do I set them? Thanks.
 
G

Guest

I finally found the properties and but am having problems with setting them
properly on the second subform. You had typed:

for the second subform, set the master to the name of this textbox
(Forms!firstSubformName.Form!SomeKey) and the child link to the foreign key

You said said to use the name of this textbox which I believe is the textbox
on the mainform but the code has firstSubFormName in it. I tried both and
they didnt' work. So, in my second subform Link Master Fields property I
would type:

Forms!MainForm.Form!txtFileNumber

if the name of my textbox on the main form is txtFileNumber?

I tried the following combinations in conjunction with different
combinations for the Child properties that I discuss further along.

Forms!MainForm.Form!txtFileNumber
Forms!SubForm1.Forms!File_Number

Then, when setting the Link Child Fields Property, I would enter SubForm2's
field name such as File_Number? Or would I enter
Forms!SubForm1.Form!File_Number? I tried all 3 such as:

Forms!MainForm.Form!txtFileNumber
Forms!Subform1.Form!File_Number
File_Number
 
Ad

Advertisements

J

Joan Wild

bsc said:
You said said to use the name of this textbox which I believe is the
textbox on the mainform but the code has firstSubFormName in it. I
tried both and they didnt' work. So, in my second subform Link Master
Fields property I would type:

Forms!MainForm.Form!txtFileNumber

Just type txtFileNumber as the Master
Then, when setting the Link Child Fields Property, I would enter
SubForm2's field name such as File_Number? Or would I enter
Forms!SubForm1.Form!File_Number? I tried all 3 such as:

Try File_Number or
[File Number]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top