How to refer to a combo-box column in a form

D

DoctorG

I have a combo-box in an Access2000 form to select the occupation of a
contact. The occupations table is linked on its first column to the master
table and only the description column is visible in the form.

I want to include this description in a report initiated from a button on
the form. I can reference standard fields using
[Forms]![thisform]![fieldname] but I cannot seem to be able to reference the
second combo-box column, despite the fact that it is visible!!

Please help out!!! And, yes, I am new to Access coding!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to refer to a form combo-box in a report 3
How to refer to a form combo-box in a report 0
Combo or list box 0
Retain combo box order 2
How do I reference a form combo box description in reports 2
How to switch combo boxes? 1
Referring to text control in a form 3
Combo Box After Update Problem 0

Top