Form Update Problems

[Lynn Renville]

I am having a problem updating forms. The form I use has
text fields, date fields and comb boxes. I can update the
text and date fields but, when I input data in a combo
box, I get a pop-up window thats says "Search key was not
found in any record". I assume this has something to do
with the properties but, for the life of me I can't figure
out how to update the form combo box fields.

Lynn

 

[John Vinson]

I am having a problem updating forms. The form I use has
text fields, date fields and comb boxes. I can update the
text and date fields but, when I input data in a combo
box, I get a pop-up window thats says "Search key was not
found in any record". I assume this has something to do
with the properties but, for the life of me I can't figure
out how to update the form combo box fields.

Lynn

Sounds like you're trying to use a combo box which was designed for
searching for new records to update the data in the table. These are
two different uses of a combo box, and they're pretty much
incompatible!

What is the Control Source of the combo? Does it have any code in its
AfterUpdate event? If so please post the code.

You may need to modify this form, or to use (or construct) another
form; it sounds like this one was designed to find data, not update
it.