form/combo box question

[Guest]

I have a form with one (equipment name) combo-box on it. The user selects
the equipment name from the list and then clicks on a button that opens a
eport on that piece of equipment. I have the table/query for the equipment
names indexed as not allowing duplicates. Everytime I use this form and then
close it, it wants to save the equipment name again but can't because I'm not
allowing duplicates. Is there any way to close a form without is saving the
info?
THanks

 

[Jeff Boyce]

Nikki

Is the combo box bound to a field in a table, or is it an unbound control,
used just to look up values?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

I think it is an unbound control. I created it meaning for it to be unbound,
but maybe that is my problem, is there any way to tell if it is bound to the
field?
thanks

 

[Jeff Boyce]

Open the form in design mode. Select the control. Click on the Properties
toolbar button. If the control is "bound", it will have a Control Source.

Regards

Jeff Boyce
Microsoft Office/Access MVP