Form not adding records

[dragon2309]

Hey everyone... got a little problem, i have the followinf form/subform setup show in the screenshot below, for ages the calendar conrol there has worked fine, its control source is the date field on the left habd side.

Now however, it doesnt work, or rather it works when your editing old records, it changes the dates fine, but when you go to enter a new record in, you cannot use the calendar, it just makes the windows error sound at me. And i cant type the date in either, and i cant type into any of the other fields either, but i can edit the old ones fine....

Of course i can just go into the original table that the form runs off and type new data in there, but thats not the point, i need to be able to use this form. It worked before, but i opened it today and its screwed sideways, lol

any help from anyon would be great, dragon

PIC:

 

[dragon2309]

14 views but no posts, someone must have an idea.... please help....!!!!

 

[ansentry]

Post a copy of you db with the form and subfrom, which you are having the problem with. Make sure before you post that it is "working" (the data sources etc) Change data so that you are not posting sensitive information.

If you do that I am sure that someone will have a look.

 

[dragon2309]

thanks for the reply ansentry. none of the data is sensitive, its all made up, for a project i have to do, so its all fine... I have uploaded it to one of my servers, the link is below, i hope you you can help me, because i have to write all of this up, and i cant take screenshots of it blank and hand that in, i really need it to work.

Thank again, dragon2309

ATTATCHMENT:

6.01Mb Access Database - DOWNLOAD

 

[ansentry]

The database has a password on it.

 

[dragon2309]

oh sorry, i forgot all about that its not exactly top secret, the password is *********

thanks, dragon2309

 

[ansentry]

Attached is a cut down version of your db. I have fixed the Main form and Subform problem.

I am a bit short on time so if you want to know how I fixed it then please send me a PM and I will explain.