Experts:
I need some assistance with using "Dcount" (or any other method) for an unbound textbox (on a form).
Attached sample database includes two (2) sample tables and two (2) sample forms.
- Table "T01_Billets" includes 10 records
- Table "T01_StaffMembers" includes 7 records but I do NOT want to count the first record (i.e., "[Vacant]"). So my count for this table should be 6 (not 7).
Forms:
- Both forms include an unbound textbox (in orange).
- For both forms, I want to include the count [i.e., 10 for Billets and 6 (7-1=6) for the Staffmembers]
- More specifically, for F10_BilletList, I later want to replace the large label "Billet List" with textbox reading: "Billet List (10)"
- Similarly, for F10_StaffMemberList, I later want to replace the large label Staff Member List" with textbox reading: "Staff Member List (6)"
I used a DCount but I don't seem to print out anything in the orange boxes on either form. What am I missing? How do I need to modify the orange textboxes to either a) get a total count for all billets or b) get a total count of staff members minus 1 (i.e., all but "[Vacant]")?
Thanks,
EEH
P.S. In my actual database, I have the form linked to queries. I didn't include them in this sample but if necessary, we can add the table/query as the data source.