Connecting Tech Pros Worldwide Help | Site Map

Update Subform when mainform info changes

  #1  
Old March 11th, 2008, 11:05 PM
Rosy
Guest
 
Posts: n/a
I have a form "A" that is set on table vessel names. I have subform
"B" that is set on table vessel info.

I want form "B" to update based on what vessel I choose in form "A".

I know this is an easy one. :)
  #2  
Old March 12th, 2008, 01:25 AM
MGFoster
Guest
 
Posts: n/a

re: Update Subform when mainform info changes


Rosy wrote:
Quote:
I have a form "A" that is set on table vessel names. I have subform
"B" that is set on table vessel info.
>
I want form "B" to update based on what vessel I choose in form "A".
>
I know this is an easy one. :)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Make sure the sub-form's Child/Master link fields are set up correctly -
i.e., there has to be a linking field between the 2 forms like a Vessel
ID or name, etc.

To find the Child/Master link fields: display the master form's
Properties dialog box.
Click on the sub-form control.
Under the Data tab ensure the link field is in the "Link Child Fields"
and "Link Master Fields" fields.
If they are empty click the build button (the button with the 3 periods)
to the right of the fields to have a wizard suggest possible fields to
link on.

--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBR9ciHoechKqOuFEgEQIZewCfUa+0/daTABTSixYHPJMPS7b3RJkAoLFm
R+u0aJndiuNBsaaIS+7c4NlU
=02+Y
-----END PGP SIGNATURE-----
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with totals on subforms Ron answers 2 August 29th, 2007 10:15 PM
Changing relationships in form john answers 3 September 4th, 2006 06:45 PM