Query Criteria Breaking

J

Jake

I am using a form (DB Maintainance) to add and delete names from a table
(Agent Names). The delete area of the form consists of a combo box (Delete
Agent Name) and a button. When the button is clicked, it opens a deleteQuery.
The query's criteria is set to the value of the combo box (Forms![DB
Maintainance]![Delete Agent Name]). This was working originally, but when I
came into work this morning, the input criteria msgBox pops up when ever I
try to delete a name. However, if I add some type of control, like a textBox,
to the form and then delete it, everything works until I save and close. If I
try to do this by setting the combo box and then manually opening the query
(not clicking the button) it does the same thing.
 
Top