C
cabong
I have 2 combobox on a form (frmPayments). The 1st combobox (cmbPeriod
has a list of years based on a table, that's ok.
The 2nd box has an SQL stmt as rowsource. Basically I want that 2nd bo
to display a list of names based on the entry selected in the 1st comb
box, upon a lookup at a query (QryPayOut).
Here's my sql stmt:
SELECT [QryPayOut].[StaffName] FROM QryPayOut WHER
[QryPayOut].[Period]=[Forms]![frmPayments].[cmbPeriod];
It workds fine but only when I load the form, it doesn't update whe
another year is chosen in the 1st combobox, what am I doing wrong?
TI
has a list of years based on a table, that's ok.
The 2nd box has an SQL stmt as rowsource. Basically I want that 2nd bo
to display a list of names based on the entry selected in the 1st comb
box, upon a lookup at a query (QryPayOut).
Here's my sql stmt:
SELECT [QryPayOut].[StaffName] FROM QryPayOut WHER
[QryPayOut].[Period]=[Forms]![frmPayments].[cmbPeriod];
It workds fine but only when I load the form, it doesn't update whe
another year is chosen in the 1st combobox, what am I doing wrong?
TI