Unbound list box

[waseemthonse]

Hi,



I am designing a DB, i have a form with 2 list box. The Main form is for staff. The first list box shows the months with paid dates. 2nd list box should show me the balance months to pay.
The main form: frmstaff
Flistbox = paid month list
Slistbox = Balancemonthlist

Tables:
TBLSTAFF
TBLMONTH( 12 MONTHS ARE ENTERED) Includes MONTHID,MONTH
TBLPAYMENTMONTHDETAIL:Includes transactioniD,DATE,MONTHID,STAFFID

Flistbox shows the paid months. It works fine.
Now the second listbox should show only theremaining months out of 12 months after checking paid months on first list.It should also check the staff ID.

How i can get the second list box with required result...

Any Help???

Thanks
Waseem

[ssanfu]

Hi Waseem,

I'm not sure I can help you, but I'll try.

What is the SQL of the list box "Flistbox"?

Is there a row source for the list box "Slistbox"?

I don't understand what you mean by "It should also check the staff ID".

Maybe you could post some sample data and the expected results??