Form with complex sourc
Posted on 2012-08-19
I've got a form "frm_ControlContact" that has as source "tbl_ControlContact", which has fields "RoleID" and "ContactID".
I need to add/update/delete the table through the form. I do combobox lookups on the form to find RoleID and ContactID in tbl_Role and tbl_Contact. I then need to display the RoleAbbrev associated with RoleID and the ContactName associated with ContactID.
If I do multiple joins in the source query I run into Dynaset Inconsistent issues which I would like to avoid.
I can't figure out how to use DLookup to get the result I want. RoleAbbrev and ContactName are unbound. The easy way would be to make them bound fields in tbl_ControlContact but that seems inelegant.
Any suggestions on this would be appreciated.