Selecting which record Combo box will display

[sharontodd]

I want to select which record a series of combo boxes get information from to
display/update. The user enters the "Division #" to select. Combo box
"First" should show the value of "First" from record "Division #". The
record source for "First" has "Division #" as the criteria. This works
perfectly with a list box but I need to see the data that is there and be
able to change it; ie a combo box.

What am I missing?

Thanks
Sharontodd

 

[Jim Burke in Novi]

It's not clear on exactly what your issue is. Are Division # and First two
fields in the same table? Do you want to show all First values for records
where Division # has a certain value? What exactly is it you need to be able
to see and change?

 

[sharontodd]

Division # is used to choose a specific record in a table. The table tracks
the div #, div descrip, first, second, third, .... the values of first,
second, etc are registration #'s assigned in a different form. The user
types a div # to pull up the desired record to see/edit who placed. I am
trying to use a combo box since I can't edit the list box and a text box
won't allow me to indicate a record source.

So, Div # and first are fields in same table and I want to show all places
for that record and be able to edit them.

Thanks.

sharontodd