form/combo box question

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
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
 
Back
Top