G
Guest
I figured out my problem with type mismatch by deleting those fields in each
table and form, then reentering them. Now when I open the form view, I get a
parameter query box for no reason I can think of. I hit ok and it letsme in.
Now, when I go from one record to another, even if not entering anything,
just going through records, I get "The value you entered isn't valid for this
field"...text in a number field(not the case) or number larger than fieldsize
setting permits. In each case, the values entered are from a drop down box
and are not numbers. If I hit OK, it then let's me proceed to the next
record and then it may or may not give me the message when I go to the next
record. This is very perplexing.
table and form, then reentering them. Now when I open the form view, I get a
parameter query box for no reason I can think of. I hit ok and it letsme in.
Now, when I go from one record to another, even if not entering anything,
just going through records, I get "The value you entered isn't valid for this
field"...text in a number field(not the case) or number larger than fieldsize
setting permits. In each case, the values entered are from a drop down box
and are not numbers. If I hit OK, it then let's me proceed to the next
record and then it may or may not give me the message when I go to the next
record. This is very perplexing.