Combo Box

M

Merv R

I have a combo box in a form, it draws it's information from a table with two
fields
description and price. I can bind either one to a field (control source) in
my form, but I wish to bind both fields i.e. when it puts the description
into say field one I want the price to go into field two simultaneously.

Merv R
 
J

Jeanette Cunningham

Merv,
In the after update event of the combo

Me.TheControlName = Me.TheComboName.Column(1)

for the second field.

Jeanette Cunningham
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo box and can it feed two separate control sources 2
Clearing combo boxes and a text box 2
Creating a Search using a combo box and then creating a report. 4
Split form 0
Combo or list box 0
Link a text box based on drop down box with four options MS Word 365 0
CLEAR MORE THAN ONE UNBOUD TEXT BOX BY CLICKING AN ACTION BUTTON 1
Cannot bind a combo box to a memo field 3

Top