Ok say i have a form pulling from a table(call is table A)
and the first combo box hold an integer that is a auto number starting at 1 (which in this case is the same number as the current record I'm in)
what i would like to do is run a query in another combo box on the same form which would look something like

Select ID
From Table1, table 2
Where Table1.ID = Table2.id

My problem with this...