Data Entry Form

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

Hi,
I have a data entry form(frmMember) bound to a member
table(MemberID, MemberName,MemberPhone, MemberFax,
ProviderID, etc.), on this form, the providerID is a
combox that a user can select a providerID from
cboProviderID combo box,this cboProviderID is bound to
the Provider table, so once the user selected a
providerID, I need to populate Providername,
ProviderPhone on the same form using the info from the
Provider table (just for display, but do not need to
save the provider info(such as ProviderName, and
ProviderPhone to the member table),but the provider info
is from a Provider table. So in the member table, just
store the ProviderID. Is there anybody can give me some
idea on how to do this?
Thanks,Jen
 
Simple
All Combo boxes have a columns property
So you would have to put this kind of code into the after_update event of
the combo:

With me.combo1
Me.PersonName = .Column(1)
Me.Address = .Column(2)
..
End With

HTH

Pieter
 
Back
Top