Combo Box on Continous form

[Tim J]

I'm have a problem with a combo(combo2) on continous form.

Its source qry is tied to another combo(Combo1) on the
same form.

combo1 is an unbound control
combo2 is a bound control

when I select the value for combo1 it updates combo2 in
every record.

can I set it so only the current record is effected by
combo1.

TIA,
Tim J

 

[Rev]

Jim, there is a known issue with combos on continuous forms... The data isn't
being updated in your underlying table though... It just looks like that in
the form. So don't go trying to fix all of your data just yet (like I did)...
There are several articles on this, I'm just not sure where they are right
now. The basic gist of the workaround is that your data is fine in the
underlying tables, but the way combos are handled by Access only references
the id column one time for the entire form (or something like that) The
result is that you see the same value on all of your records. If you must
have a combo on your subform, which most of us do from time to time, you
create the combo on your subform, then create a textbox to hold the data. Use
the two in conjunction... so the combo updates the text box or the textbox is
the bound object. Make your combo box so that you only see the dropdown
arrow... sometimes a strategicly place lable can make it look perfect. If you
need further assistance I can post an example somewhere of a solution I
created for this several years ago. It does exactly what the literature--
that I can never seem to find--instructs us to do.
I'll see if I can find the KB article for you.
rev.