Problem with default date in form

[marathonlady]

I have a form that has a date field. When a new record is added
I had the default on the date field to be the current date. This worked fine on my pc (Windows2000 op sys), but on the users pc (NT), the #NAME came in the date field, but they were able to enter a date in the field. So I made a change that when a new record came up, in VB code I set DateField = Date(). What happened on my machine is because the date was set in VB, it tried to add the record to the table without the key field (parcel number) which gave an error. Has anyone had this problem?

How do I set the date to the current date and not having a record yet added to the table?

 

[ghudson]

In the design view of the table, set the default value for that date field to =Date()

This will only fill in the current date for new records.

HTH

 

[R. Hicks]

Pat is correct (as usual). It could be a missing reference that is realy not missing. NT place files in different folders than Windows does. If the app is trying to reference a libary that should be at a specific location and it not there ..... "Missing" library reference. This will cause many built in functions to error such as you are getting with the Date() function.

HTH
RDH

 

[marathonlady]

I've check references on users machines

I have checked the references. Could one be missing even though none say "MISSING"?