Need help with a combo box

[Guest]

I need help I have created a table that list types of owners and have created
a forein key in the owners table and I have linked this to a one to many re.
I have also created a qlkpTypesOfOwners. I designed a form and when I place
the control on the form it shows the type of owners in the combo box, but
does not allow me to select one. I want the value that is select for the
record to remain in the owners table....what do I do

 

[Pieter Wijnen]

you must set it's controlsource (properties page)

Pieter

 

[Guest]

Thank you Pieter for your response, however I have check my form and there
are no locks, and it is allowed for data entry. My form is based on a qry
that is based on 2 tables, I have one table that is only the ownertype and
have one of my tables referenceing it, by look up value. I created the
qryform and from the 2 tables and selected the BOType as one of the fields to
include in the qry. I created a form base on that qry and when I selected the
field botype using the wizard combobox and placed it on the form. It still
will not allow me to select from the drop down list.

Table1: BrokerageOwner
Table2: Center
Table3: BOType
Qry:QryMain
Which includes: Table1 & Table2 with Table1 referencing Table3 for the field
BOType-Lookup

Thank you very much for your time, I really appreciate it!
Terra

 

[Guest]

I need help I have created a table that list types of owners and have created
a forein key in the owners table and I have linked this to a one to many re.
I have also created a qlkpTypesOfOwners. I designed a form and when I place
the control on the form it shows the type of owners in the combo box, but
does not allow me to select one. I want the value that is select for the
record to remain in the owners table....what do I do