I have no default value set for the StationID field on my Tasks table - in fact, I don't even have that field on my Tasks form. But when I make a new record on the form, a default value is copied into the table. When I make a new record on the table, a default value is not created.
What could be creating that default value when I make a new record using the form, even though that field is not even on the form?
Thanks!
CB55
You likely have the StationID field set to autonumber in access?
This would make it automatically populate with an incremental value every new record. This is actually a good way to keep a unique identifier in tables
You dont need to have the value on the form, the databse will do it automatically. Also when you enter a new record in the table you said it doesn't create a value? Did you try tabbing down to the next record? Thats when the insert actually takes place and you will probably see then a value appear.