Form/Subform question...

[Guest]

Here's what I want to do and it would seem that Main Form / Subform would be
the way to go.
I have a table that contains information about a customer. I would like to
be able to select the Customer in the main form. Then on the subform have
the Customer data shown for the Customer in the Main Form. The client does
not want to use Record Selectors as the number of clients can be large and
they like the dropdown box functionality.

So the question is:
How do I set up a Form/Subform to accomplish this? The main form has only
the dropdown box which contains the Primary Key and Customer Name. The
subform has the Primary Key and all other data.

Any thoughts would be greatly appreciated.

 

[Guest]

Both forms are based on Queries of a Table.

 

[Rick Brandt]

Here's what I want to do and it would seem that Main Form / Subform
would be the way to go.
I have a table that contains information about a customer. I would
like to be able to select the Customer in the main form. Then on the
subform have the Customer data shown for the Customer in the Main
Form. The client does not want to use Record Selectors as the number
of clients can be large and they like the dropdown box functionality.

So the question is:
How do I set up a Form/Subform to accomplish this? The main form
has only the dropdown box which contains the Primary Key and Customer
Name. The subform has the Primary Key and all other data.

Any thoughts would be greatly appreciated.

The main form does not need to be bound at all. All it needs is the ComboBox.
If they are both bound to the same table you could have locking conflicts. Also
a bound ComboBox on a bound main form would mean that you were actually editing
the first record when you make a selection (not what you want).

You could just use the subform by itself and place the unbound ComboBox in the
form header. Code in the AterUpdate event of the ComboBox could filter the form
to show the selected record or it could navigate you to the selected record. I
prefer the filter method myself, but the CombBox wizard will build the
navigation type of control for you.