Drop-down relationships

[mattborn]

Ok,

I've got a form with a drop-down list that pulls the data for that list from another table. The problem that I am having is that when you create more records, that choice that was chosen from the drop-down list isn't saved to that record.
For example: I choose '5' from the drop-down list for one record, but when I go to any of the other records, they are all '5' as well.

I've tried every possible relationship, I think, but nothing works.

Please help, thanks.

 

[JeremyNYC]

Matt,

It sounds like your combo box is not bound to a field in the datasource for your form. The way you want to set up a combo box is that it gets its data from one place (the comboboxes rowsource) and stores its data in another (the control source the combobox should be a field in the form's recordsource).

In the properties for your cbo, pull up the data tab. The top slot is for control source. If you pull down the arrow there you'll be able to choose one of the fields in your form's recordsource.

Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.