Re: [MS_AccessPros] Autofill in subform

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]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/