Please explain concepts

[Lee Hunter]

I want to add records to Table A from fields in Tables B & C.

I have create a form bound (by record source) to Table A

I have created a combo box for Field 1 using Control Source for Field 1 and
record source of Table B.

I have created a list box for Field 2 using control source for Filed 2 and
record source for Table C.

The form boxes contain the correct values, but when I try to select the one
of the records from the combo box, nothing gets selected and no record is
added to Table A

Please correct my conceptual misunderstanding.
Thanks!

 

[Tom Wickerath]

Hi Lee,

What you are doing sounds correct. Are you only having a problem with the
combo box? In other words, is your list box working correctly? (I assume that
your listbox has it's Multiselect property set to None, so that it has a
field from table A specified as its Control Source).

Make sure that the Enabled property for the combo box is set to Yes, and
that the Locked property is set to No.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________