Updating a text field from a combo box.

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Hi again. I think I messed up and somehow posted my last
entry before it was done. So here I go again.

I have a combobox on a form that lists the records I have
in a table called "Beans". There are two columns in the
table; "Bean_ID" and "Bean_Title". The combobox works
fine and the code looks like this:
SELECT Beans.Bean_ID, Beans.Bean_Title FROM Beans
The combo box displays Bean_Title.

Now, I have a text box on the form called Beans_Txt. All
I want to do is get the value of Bean_Title into Bean_Txt.
On the afterupdate event on the combo box, what do I do?

Thanks,
Dan
 
Back
Top