Add description

K

knock

I have done a form for "Visit details", in the form, there is a drop-down
list for service ID. However I like to add the description of the service to
the form, so I know that Im selecting the correct one. How do I do this?

Kn
 
J

Jeff Boyce

If you have a drop-down (a combobox I assume), you don't have to show the
first item (usually an ID). You can set the column width of the first item
to zero (0) and show the second field in the query underlying the combobox,
usually the short title or description.

This way, you don't need to add an extra control to your form.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
K

knock

Dear Jeff

I have tried to do what you recommend, however this doesnt work. Can you
give me more details/instructions.

Regards
KN
 
J

Jeff Boyce

"doesn't work" doesn't give us much to go on. Can you be a bit more
descriptive? What happens?

"have tried to do" doesn't really describe what you did ... it's hard to
offer specific suggestions without knowing what you have already done.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Top