Hi - I'm quite new to VBA, using Access 2007. Apologies if this is a stupid question !!
I have created a form for users to view the details from a table, so they can edit fields in that table - e.g. where the optical mark reader has misread a field on the paperwork. What would be easiest for the user would be if the DLookup gave the explanation of the field rather than just the code letter, but I need the table to always have just the letter stored.
Is this possible?
For example, the table has letters a-n representing different answers for the date the property was built.
I use a combo box with two columns to show the letter and the explanation e.g.: a;before 1900;b;1900-1920 etc.
If I make the 1st column to be width zero, it only shows the explanation in the drop down menu, but the DLookup query doesn't seem to work as the field is blank. The letter only shows if I have column widths for both letter and explanation in the combo box.
I also need any change to be stored as the associated letter in the table.
I have been using a Value list as the row source. There are 20 fields which could be edited.
Any advice gratefully received !! Thank you.