Combo box and text box combined

S

Steve

I am struck on this database part and ive been trying to
work out how to do the following:

Combo box and text box combined so when i select a
product from the combo box it automatically goes into the
text box. How do i do that?
 
A

AlCamp

Steve,
The Combobox "IS" your text box. The ControlSource of your combobox
should be a field in your table. You allow the user to select a value from
the RowSource of your combobox, and after that selection, that value is
stored in the table field specified in the combo ControSource. It's called
"binding" your field to the combobox.
There should be no need to have a text control to store the combo
value... the field "bound" to it will store the data.
hth
Al Camp
 

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

Top