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]
> >
>
Tidak ada komentar:
Posting Komentar