Combo box from a macro

J

Joe C

Hello,

First let me give you the scenerio. I have a main form of data. On it I have
a subForm. I want to select a record from the subform (which is sub-data)
and display that record in the main form.

This is a customer and related customer DB. When Customer X comes in I want
to be able to see customer x's family. I want to be able to choose a mamber
of custome x's family and display them on the main form, thus displaying
customer y and their family.

I have created the main form to have a combo/lookup based on the SS#.
I have created a button on the subform to read the SS# on the subform and
set the value of the combo/lookup to it.
What I need to do is redo the combo/lookup so it may lookup the value in the
combo/lookup and repopulate the form.

Does this make sense?

Thanks
2007 WS Champion Papi
 
Top