Non Access programmer trying to help a friend

[SRussell]

I was asked to add another sub form to existing app. I have added the new
tables for it, and I am stuck in populating the fkey back to the main page
that this sub form is on. I know it's going to be easy, but I am at a loss
in getting it to work. The other sub forms all work this way and I can't
seem to find anything on the properties section, nor in the data tables.

So how do you pass the main pages PKey down to the sub form?

TIA

__Stephen

 

[Rick Brandt]

I was asked to add another sub form to existing app. I have added
the new tables for it, and I am stuck in populating the fkey back to
the main page that this sub form is on. I know it's going to be
easy, but I am at a loss in getting it to work. The other sub forms
all work this way and I can't seem to find anything on the properties
section, nor in the data tables.
So how do you pass the main pages PKey down to the sub form?

The settings of the MasterLink and ChildLink properties of the subform control
take care of that. Make sure you look at the properties of the subform
*control* not of the form within.

 

[SRussell]

The settings of the MasterLink and ChildLink properties of the subform
control take care of that. Make sure you look at the properties of the
subform *control* not of the form within.

Thanks Rick. I may have not made the SubForm properly??? I just hit the
help on make a sub form. I instead just made a form and dropped it ontop of
the existing tab control.

Do I have to remake this "easy" form?

 

[Pieter Wijnen]

no, just set the control's properties

Pieter

Thanks Rick. I may have not made the SubForm properly??? I just hit the
help on make a sub form. I instead just made a form and dropped it ontop
of the existing tab control.

Do I have to remake this "easy" form?

 

[Rick Brandt]

Thanks Rick. I may have not made the SubForm properly??? I just hit
the help on make a sub form. I instead just made a form and dropped
it ontop of the existing tab control.

Do I have to remake this "easy" form?

That's exaclty how I make them. the "how" doesn't really matter except that
in some cases Access will fill in the link properties for you.

 

[SRussell]

"Pieter Wijnen"

no, just set the control's properties

Pieter

Thanks. I am lost as to which control I am looking for? The Form itself,
or the textbox that shows the data, in this case a repair order #. I can't
seem to find anything on the form or the textbox that says child link.

To get to use this access file I have to hold down the shift key when I
click on it. this shows the Access 2000 environment. I have no idea what
version the orig was written in? I have 2003.

Thanks again.

 

[SRussell]

That's exaclty how I make them. the "how" doesn't really matter except
that in some cases Access will fill in the link properties for you.

Thanks Rick. Where are the properties for the link set? I have my subform
open, I have "form" in the list of what properties I'm dealing with. I
don't see any reference to link, or child link.

I am opening up this file with a Shift + click so I can see the menus of
Access. It displays access 2000 in the title of my database if that
matters.

Thanks again.

 

[SusanV]

Open the main form in design view, then click on the subform control - not
the subform itself - the outline of it if you will. The properties window
will be titled "Subform/Subreport:YourSubformName" rather than "Form" and
the link properties are on the Data tab.

 

[Pieter Wijnen]

Open the Form in Design View
Open The Properties window (Alt + Enter), Or Click the 'Hand holding a card'
icon on the toolbar
Locate The SubForm Control ,easiest is in fact to hitting TAB 'till the
SubForm Control has focus, Else It's more likely you Activate The subForm
instead of the control ,
Or Select it from The ComboBox in the Formatting Section of the Toolbar.
Look For Link Master & Child Properties & Add The Field Names

HTH

Pieter

 

[Pieter Wijnen]

Locate it On The Main Form, And Oh yes if you have the subform open in
Design View, It's much easier to select the control on the main form

Pieter

 

[_Stephen]

"Pieter Wijnen"

Open the Form in Design View
Open The Properties window (Alt + Enter), Or Click the 'Hand holding a
card' icon on the toolbar
Locate The SubForm Control ,easiest is in fact to hitting TAB 'till the
SubForm Control has focus, Else It's more likely you Activate The subForm
instead of the control ,
Or Select it from The ComboBox in the Formatting Section of the Toolbar.
Look For Link Master & Child Properties & Add The Field Names

Thanks. I can follow those directions !!!

Now I'm at the day job so I'll look to this later. I appreciate your
assistance.

__Stephen