Hi Dennis,
Glad to be of help.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, Dennis Davidsson <dennisdavidsson@...> wrote:
>
> Thanks a lot Clive!
>
> Kindly regards
> Dennis
>
> 28 jan 2012 kl. 12:57 skrev Clive:
>
> > Hi Dennis,
> >
> > The file I mentioned, Form Object Addressing.xls, is in
> > the GroupFiles Articles_Excerpts folder, and you can
> > download it from there.
> >
> > Regards, Clive.
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@> wrote:
> > >
> > > Hi Dennis,
> > >
> > > You can do it with code like the following.
> > >
> > > Private Sub Form_BeforeUpdate(Cancel As Integer)
> > > If IsNull(Me.Controls("PhoneNum")) Then
> > > Me.Controls("PhoneNum") = Me.Parent.SwitchBoard
> > > End If
> > > End Sub
> > >
> > > where "PhoneNum" is the name of the field in the SubForm
> > > and Switchboard is the name of the field in the MainForm.
> > >
> > > Hope that helps.
> > >
> > > By the way, there was a useful file in the GroupFiles
> > > that shows how to reference Forms from subForms and
> > > vice versa but I can't find it. I wil try to send you
> > > a copy that I have.
> > >
> > > Regards, Clive.
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, Dennis Davidsson <dennisdavidsson@> wrote:
> > > >
> > > >
> > > > Hello,
> > > >
> > > > I have form called Adressregister, in which I register misc. address information for my customer companies.
> > > > This form has a subform called Kontaktpersoner, in which I register misc. information for each contact person belonging to the company.
> > > > Among the address information that I register in the main form is e.g. the telephone number to the switchboard of the company.
> > > > But also on the subform Kontaktpersoner I can register the specific telephone extension to the contact person.
> > > > Now, when I register a new contact person I want the telephone number in the main form Adressregister to be automatically filled in in the telephone number also in the subform as a default.
> > > > How can I accomplish this?
> > > >
> > > > Kindly regards
> > > > Dennis Davidsson
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> >
> >
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar