Ok let me see if I got this right.

You have two tables: Antiques and Collectibles.

Antiques is build up the following fields:
- Antique_id (This is the primary key)
- Antique_description

Collectibles has the following fields:
- Collectible_id (Primary key)
- Collectible_description
- Collectible_Antique_id (Foreign key with the Antique_id of the Antique
table)

I hope this is your structure, if not, please post yours.

Ok let's say you have a form with two comboboxes on it named: cboAntiques
and cboCollectibles.

cboAntiques.RowSource should be something like this: "SELECT Antique_id,
Antique_description FROM Antiques"

In the OnClick Event of the cboAntiques you can try the following code:

'begin code
Dim strSql As String
'build sql string based on selection in cboAntiques
strSql = "SELECT Collectible_id, Collectible_description FROM Collectibles
WHERE ((Collectible_Antique_id = " & Me.cboAntiques & "))"
'change list items
Me.cboCollectibles.RowSource = strSql
'refresh list items
Me.cboCollectibles.Requery
'end code

Alternatively you can put the same code in the AfterUpdate event of the
cboAntiques combobox.

Please see which one suits you best.

I hope I have understood your problem and was able to give you a workable
solution.

Have a nice day,

Kashaan.