Combo Box Control Source ? ? ?

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
 
G

Gary Miller

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
________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top