Continuous Form Date textbox control default value 1/1/1925? 1

[misscrf]

I have a SQL database linked into Access for form data entry. On one continuous subform, for a new record, the date field shows 1/1/1925, as it if has been set as a default. When I go to the linked table that is not there, and in SQL that is not there. I checked all properties at the SQL level and the textbox control on the form.

Does anyone have any idea why this is happening and how to make it stop? I greatly appreciate any ideas on what the heck is going on.

Thanks!

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[dhookom]

Try create a new form based on the same linked table to see if the default is 1/1/1925. If it is, then the issue is in your SQL table. You should be able to over-ride the default in the form by setting the control's default value.


Duane
Hook'D on Access
MS Access MVP

 

[misscrf]

ok so that was a great suggestion and I don't know why I didn't think of it. I did that, and the new form did not have the default value showing up. Ok, good. So I delete that control on the other form and make a new one, still happening.

Then I start thinking, wait - my records are not showing up. I check the tables and the foreign key is set for 2 records and should make those records show up for that main id.

Then I think, hmmm I'll check the subform links. Sure enough when I added the subform control I couldn't see what link it was suggesting. I just clicked the first one. It wasn't what it should be (main form PK and subform FK) it was Date of birth on both forms!!! wierd!

In any event, your suggestion led me to my solution, so thanks a bunch!!

misscrf

It is never too late to become what you could have been ~ George Eliot