My combo box seems to return the correct text from the specific table used for that combo box in my form. BUT the query
receives a number? what am I doing wrong?
My combo box seems to return the correct text from the specific table used for that combo box in my form. BUT the query
receives a number? what am I doing wrong?
Depends on what your combo contains?
I tend to have the bound column as my first column, which is always hidden, the the descriptive column as my 2nd and any other columns after that.
However the key that everything is linked by is the first column, usually an autonumbet.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
That's how multi-column combobox should work - assuming you are using autonumber field as primary key and saving that value to dependent table as foreign key.
Where are you using this query - form or report?
Advise not to build lookup fields in tables.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
In your query you would include the table that contains the values for your Form Combobox and
you then add the field from the table and not the ID number from the related table.
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description