Thanks to all who have helped with my update form. Nancy Folsom's
comments have been especially useful.

I have used the debugger to step through the code and have a better
feel for how this is working now. Plus I have narrowed down the
problem and can associate the difficulty with a combo box on the
form which I'm using for lookup. I'm updating a client file, and
trying to provide an alpha lookup on the same form. I didn't think
to mention the combo box before, but as soon as I add it to a test
form, the problem reoccurs. By the way, I've tested this with the
BoundTo property on the ComboBox set to .T. as well as .F.

I have the interactive change event set to thisform.refresh, and
it navigates through the table correctly. But when I try to add
a new record, this process is messing up the operation. When I
tab to a new field after the append blank occurs, the value from
an existing record appears in the field. It looks like the pointer
isn't staying on the new blank record. What is strange is that I'm
not doing any interactive changes to the combo box, yet the data
from an existing record is still showing on the form.

The add process works fine when I take the combo box off the form,
so I don't think I need to modify the wizbtns class I'm using. But
I will need to provide an easy way to get to the right record and
a combo box lookup sure is appealing.

Has anybody seen anything like this?

- Bob Longmire
- Hillside, IL