Listbox Help

[allykid]

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.

[orange]

Really,
See post #10 here
http://www.access-programmers.co.uk/...d.php?t=207176

[jzwp11]

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.