Combo Box Control Source ? ? ?

  • Thread starter Thread starter Dodge Brown
  • Start date Start date
D

Dodge Brown

Hi All


I have a form which has a Datasource of "Table X" and 2 Child Sub-Forms
linked to 'Customer' on "Table X".

I am currently using a unbound text box to display 'Customer Name' and the
navigation arrows to scroll through.

How can I Use a Combo Box to Select 'Customer' on the Form for the 2
Sub-Forms ? ? ?


Any Help would be Greatly appreciated.


Thanks in Advance

Dodge
 
Dodge,

I am a little confused as to what you are looking for as I
read your post. I am curious how using the nav buttons would
let you scroll through the Customer Names if that is an
'unbound' text box.

If your subforms are setup properly, they should reflect the
child records of whatever Customer the main form is parked
on and should change every time the Customer changes.

You can use the combobox 'Wizard' to help you build a
combobox that you can put in your form header to jump to
whatever customer you want if that is what you are asking.
Choose the option to 'Find a record on my form based on the
selection'.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top