Linking List Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good day everyone.

I have two Tables:
First Table Called Stage1
One Field Called (Type)

The Second table is called documents
This table has two fields:
1st called (Type2) which contains the same info has in the stage 1 table
2nd with the document number

The relastionship between the two tables is one to many between the two
types (type and type 2)

Basically I would like to have a combo box that diplays the information in
the stage table. When it is selected the documnet number is displayed in the
list box.

Hope this makes sense,

Any help would be greatly appreciated.

Thanks
 
Hi,


You can change the RowSource (of a list box, or of a combo box) at run time.
In the After Update of the Combo box, as example, you can use:

' Debug.Print Me.YourComboBoxName
Me.ListBoxName.RowSource = "SELECT ... FROM ... WHERE stage =
FORMS!yourFormName!YourComboBoxName"


Sure, check to see if your combo box return the appropriate value (which is
NOT necessary the displayed one, as when there is some "lookup"
translation ).



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top