Assistance with Comboboxes

  • Thread starter Thread starter lauriecking
  • Start date Start date
L

lauriecking

I have a combo box on my form that I have added a query on the form.
So you go into the form, you will see a Site # with a combo box. Click
on the items in that combobox will display as follows:

1 Home Office

So everytime I try to add a new record into my form. It will add all
the information but the Site # is one field and it is updated with the
information. The Site Name is another field in my table that is still
null. Does anyone know what I am doing wrong on this?

Thanks
 
So everytime I try to add a new record into my form. It will add all
the information but the Site # is one field and it is updated with the
information. The Site Name is another field in my table that is still
null. Does anyone know what I am doing wrong on this?
Click to expand...

Assuming that you need to store the site name redundantly in your table. You
don't. The siteID is all you need; it is neither necessary nor beneficial to
also store the site name. You can always use a Combo Box (on a form) to
display it, and you can use a Query joining the two tables to put it in a
report.

John W. Vinson [MVP]
 
Back
Top