View Full Version : Minor Access version upgrade is breaking my form


a2ari
05-09-2007, 07:25 AM
I have a date field on one of my forms that gets populated automatically when a new record is created. I also have a subform on the form that lists the tasks that still need to be accomplished this month.
Some problems have popped up as people got new computers with new versions of Access:

Access 2002(10.6501.6825) SP3 - No problems.
Access 2002(10.6771.6817) SP3 - The Date field isn't recognised on a new record (#Name?), but it's fine on the old records (displays date).
Access 2002(10.6771.6825) SP3 - The reminder subform is blank (white), as if it doesn't exist, but the date field works fine.

Any ideas why this might be/how to fix?

Thanks! This is really frustrating. If it didn't work for anyone, I would find a way to fix it, but because it works for some people, I don't know what to fix...

Simon_MT
05-09-2007, 11:33 AM
I have seen this and usually trash the field and reconstitute it after checking that the references in VB the same.

Generally, I only install form from one CD and get everyone on the same version at least if anything goes wrong its wrong on all systems.

Simon

a2ari
05-09-2007, 11:45 AM
I don't have that luxury, as I do not control what version of Access is installed on the machines.

As to the fix, I'll give it a shot, thanks.