Cascading Bound Combo Boxes

[Guest]

Hi,
I am using Access 2003 to create a time tracking database. On the Time
Entry Form I have cascading combo boxes for Category and Task each being
generated from a Category or Task table. I have imported the 2005 data from
Excel and created a Time Entry Table. The fields on the Time Entry Form are
bound to the fields in the table. The combo boxes are working fine, but when
I open the form I get the following error message: "The value you entered is
not valid for the field." I get this message twice per record. The
information in each record is correct. I have also verified the data type in
the Time Entry, Category and Task tables and it is text in all cases. Has
anyone run into this before, and can you give me some tips to fix the form so
user's don't see the error message? Thanks for your help.

 

[tina]

hmm, you might check the table underlying the form, and see if any of the
fields have a DefaultValue set - especially in fields with a Number data
type; Access unfortunately sets a zero (0) default value to all number
fields automatically.

hth

 

[Guest]

I looked and only one field is a number data type, and it didn't have Default
Value set. Neither did any of the other fields. Thanks for the tip though.