default value date() in form problem

[Michelangelo]

Hi,

I've got a strange problem and can't solve it. I distribute a database among multiple systems with multiple setups. Work fine normally, but now on one machine (XP) one form with a unbound textbox with the default value set to "Date()" without the quotations marks, doesn't work. It displays #name instead of the date. On all other machines it works perfect.

Any ideas??

 

[Mile-O]

Have a look at the references and see if one is missing.

 

[Michelangelo]

Have a look at the references and see if one is missing.

None are missing. I've tried to uncheck / recheck them, worked for all exept for the first two, Visual Basis for Applications and Microsoft Access 9.0 Object Library, in which I think the relevant reference is. It displays a message that it can't change it because it's used.

Come to think about it, I recently updated the XP machine to SP1, could that be it??. Can I replace the new dll/ocx with the old one????

 

[Rich]

Uncheck one of the others or just check one that isn't, then compile and save