Subforms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main form with three subforms. The linking field on all forms is
called MR Number. When I populate information on the subforms, I want the MR
Number entered on the main form to automatically populate the MR Number on
the subform(s). How do I make this happen?
 
On Mon, 13 Dec 2004 10:25:07 -0800, Dick W <Dick
I have a main form with three subforms. The linking field on all forms is
called MR Number. When I populate information on the subforms, I want the MR
Number entered on the main form to automatically populate the MR Number on
the subform(s). How do I make this happen?
Click to expand...

Umm...

Why?

Creating empty "placeholder" records containing nothing but the
linking field is generally neither necessary nor beneficial. The blank
records have a way of never getting filled in; they just take up
space. The MR Number will fill in automatically at the first keystroke
of a user entering data into the subform.

Is this not happening for you? If not, what are the Master Link Field
and Child Link Field properties of the subform controls?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Sorry, I was too brief when describing my Access situation. The MR Request
on the subform is not automatically filling in when I enter the first
keystroke in the subform. I am somewhat of a novice when it comes to Access
so I'm not sure if I'm answering your question about the Master Link Field
and Child Link Field properties of the subform controls properly. When
looking at the subform properties the Master Link Field and Child Link Fields
reflect the MR Reqest field from the main and subforms respectively. I
have also compared the properties of this database with one that works and
have not found any differences.

Thanks in advance for your help.
 
Back
Top