Full Version: unbound List box
UtterAccess Forums > Microsoft® Access > Access Forms
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
ables:
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
cwfitz
If MonthID is a set of sequential numbers (i.e., 1 - 12) you could use as the RowSource for SListBox:
"SELECT MonthID, MONTH FROM tblMONTH WHERE MonthID > " & FListBox
waseemthonse
Hi,
I tried, It is not showing anything. FListBox is showing the months fee collected.But i need remaining months to show in the SListBox. The month table "tblMONTH" is having 12 months. It should show depending on the STAFFID. IF STAFFID is 1 ,then it should show fee collected for satff1 in SListBox.Balance fee months in SListBox...
Any Help?
Thanks
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.