error msg from navigating between records on Access form

W

Wendy Farkas

In a table datasheet and a query produced from it (displays all table fields)
I can move between records using the navigation buttons. However, in a form
based on the table's query, whenever I try to use a button to navigate to
first, last, next or previous record, I get this error message:

"The value you entered isn't valid for this field."

I've checked all fields to make sure that zero entry is allowed (except for
autoID) and expanded the field size. Whatever can be going on here?

Thanks
 
W

Wendy Farkas

They're the standard navigational buttons (I haven't customized them).
They're the ones that work fine on all the other datasheets and forms
 
K

Klatuu

This is pretty bizarre.
Does this happen whether or not you have changed any data on the form?
 
W

Wendy Farkas

User opened the form to find a record to edit - nothing had been changed
prior to that.
 
V

Van T. Dinh

Sounds to me some value has been set by code. Use the Form_BeforeUpdatte
Event with a simple MsgBox to see if it fires when you navigate to another
Record.
 
K

Klatuu

Good Idea, Van. She could also look through the form's properties in design
mode to see if any default values are set or any events are firing that
modify values.
 
Top