Juts a quick one on this, is it possible to use a field only within a recordset in the drop down box?
On my example, it selects ContactLastname from TblContacts, and writes the ContactID to the table. I would prefer if it could write the ContactFirstname + ContactLastname as this means more to the end user. They wont understand what/who ContactID78 is for example.
In a recordset I created I have concatenated the fields as:
SELECT CONCAT(contactFirstname,' ',contactLastname) fullname, tblcontacts.ContactID
Could I have this recordset as the source for the dynamic menu/list, I have been looking at it for hours without any success.