Combo box on Form will write to table

  • Thread starter Thread starter Frank
  • Start date Start date
F

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?
 
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.
 
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.
 
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
 
How do I base a form on a specific table? And how do I
"bind" the combobox to the filed? Thanks!
 
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
 
Back
Top