How do i get a combo box to enter data in a table from a form?

J

Joe Owens

I want to use a form for data entry. Within that form I have two combo boxes
to look up recurring data. When I select an item and expect it to write to
another table it does not. What must i do to accomplish this?
 
K

Ken Snell \(MVP\)

You'll need to tell us more details about your form's setup and the tables'
designs. Your question suggests, though, that you may be storing data
redundantly in your database, which usually is unnecessary and may be a
source of future data integrity problems.
 
J

Joe Owens

I have two tables that I am using as a source to my form. One has dates
(10/10/2007) the other has a series of names (Joe Owens). The form I am using
will be upated weekly, but only specific values which are check boxes. I want
to be able to use the combo boxes to reduce typing.
 
K

Ken Snell \(MVP\)

What is the form's RecordSource query? Are you actually trying to update the
data in these two tables via your form, or do you want to use those two
tables as "lookup" values that you then enter into whatever table is being
updated by the form?
--

Ken Snell
<MS ACCESS MVP>
 
Top