I can't get a listbox to populate... I have attached a sample of my work.
Relativley new to VBA and SQL so please be brutal.
Thanks.
I can't get a listbox to populate... I have attached a sample of my work.
Relativley new to VBA and SQL so please be brutal.
Thanks.
Really,
See post #10 here
http://www.access-programmers.co.uk/...d.php?t=207176
You had some spelling errors in your code relative to your field names, you had EntitlementsID, there is no "s" in the field name. Also, the EntitlementName field has a space so it should be [Entitlement Name]. Additionally, the subquery should be enclosed within parentheses.
Also, for the 2 list boxes, you did not have the row source type defined as table/query.
The corrected DB is attached.