Combo Box in Continuous Form

[remmons]

I'm having a problem that I see posted here several times and while I
understand the concept of the fixes that have been posted, I can't seem to
put it into play.

The solution I'm working with was posted by Tom Wickerath on 12/3/08:

“…the problem you are seeing is due to the fact that there is really only
one combo control - it is just displayed multiple times. So whatever you have
for current rowsource will apply to all rows. This makes it difficult to use
synchronized combos on continuous forms. However, there is a fairly easy
workaround. To create the effect of a synchronized combo in a continuous form
create another textbox control, include the display column of the combo in
the Recordsource query of the form (join the foreign table and drag in the
column). Position and size the new textbox so that you can place it directly
over the combo box allowing only the down-arrow portion of the combo to show.

Create a GotFocus event for the textbox that only does a SetFocus to the
combo."

The one instruciton that I don't quite understand is this line:

"include the display column of the combo in
the Recordsource query of the form (join the foreign table and drag in the
column)."

Can someone please clarify this statement?

 

[remmons]

Ok, I understand now. I think my problem lies in the fact that I'm using the
subform to edit data so I can't use the query as a record source. Thank you
for clearing this up.