Autocomplete of specific fields in a Form

[Guest]

Hi all,

I have a form with tabbed pages. At the top I want the user to select a Vendor ID, the next field contains the Vendor Name, but I want this to come up automatically when they select the Vendor ID. Other data has to be entered by the user on other fields on the form as well as in other subforms.

I have tried creating an autolookup query and putting this in the form. However, it doesn't seem to work.

Any help is greatly appreciated.
TIA

 

[Reggie]

Bling, Assuming your vendor combobox has 2 columns(VendorID & VenderName)
set the after update event of the combo to something likeKeep in mind the
combo boxes are zero(0) based so that column 1 is actual column 0.):

I'm assuming that the VendorID is in the first column.
Private Sub VendorCombo_AfterUpdate()
Me.VendorName = Me.VendorCombo.Column(1)
End Sub




--
Reggie

----------

Hi all,

I have a form with tabbed pages. At the top I want the user to select a

Vendor ID, the next field contains the Vendor Name, but I want this to come
up automatically when they select the Vendor ID. Other data has to be
entered by the user on other fields on the form as well as in other
subforms.

I have tried creating an autolookup query and putting this in the form.

However, it doesn't seem to work.

 

[Guest]

Thanks Reggie, will try it out.

Bling, Assuming your vendor combobox has 2 columns(VendorID & VenderName)
set the after update event of the combo to something likeKeep in mind the
combo boxes are zero(0) based so that column 1 is actual column 0.):

I'm assuming that the VendorID is in the first column.
Private Sub VendorCombo_AfterUpdate()
Me.VendorName = Me.VendorCombo.Column(1)
End Sub




--
Reggie

----------

Vendor ID, the next field contains the Vendor Name, but I want this to come
up automatically when they select the Vendor ID. Other data has to be
entered by the user on other fields on the form as well as in other
subforms.
However, it doesn't seem to work.