Combo box on Form will write to table

[Frank]

Hi, I have a form containing a combo box. I'd like the
value that the user selects to be saved in a field on a
table. How can I do this?

 

[PC Datasheet]

Presuming you already have the table, create the form based on the table. Use a
combobox to select a value to be entered in the said field. When you close the
form, the value in the combobox will be automatically saved to the table.

 

[Guest]

First, the form is already created. Secondly, the combo
box is the list of values in Table #1. I want the selected
value to be saved in a field on Table #2.

 

[PC Datasheet]

Base the form on Table#2. Bind the combobox to the field. Clocing the form will
automatically save the selection in the combobox.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

 

[Guest]

How do I base a form on a specific table? And how do I
"bind" the combobox to the filed? Thanks!

 

[PC Datasheet]

Open to the database window and go to the Forms tab. Click on new and use the
Forms Wizard. Follow the directions and you will do both.

Steve
PC Datasheet