Variables in Forms

[NewDeveloper]

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 is it works for table 1 but the information never changes is there any way i can make a variable so my where clause would change when i changed records



something like

WHERE [CurrentRecord Number] = Table2.id

[is49460]

try to do the comparison by the primary key