Part Two: I have no idea how to do this!

[Mala]

(Please read "Part One" of this message to get the set-up)

My other issue is that on the second form (with a subform
linked to tblA) if I want to add a combo box connected to
another table, I can't!

I want to use the wizard to select the "Find a record on
my form based on the value I selected in my combo box"
option. If I want to link the combo box to tblB, tblA is
my only option.

I haven't been able to duplicate the functionality of
the "Find a record..." option without going through the
wizard, but without the wizard I can't change the
table...and I need to!

Any suggestions with this?

Thanks in advance for any help with this or Part One.

Take care,

Mala

 

[Ken Snell]

Unless tblB is part of the form's recordsource, the wizard won't set up the
combo box the way you want.

If what you want is to use values from tblB as the selection options so that
you can find a record on the form that is based on tblA, you could use the
wizard to set up the combo box. Then go to the Row Source box in the
Properties window, click on the "..." box at far right, and modify the query
to change it from tblA to tblB.