Table Default not populating

[slankc]

We are using Access 2002 and Windows XP

I have a table in a back-end database that is being updated by a form in a front-end (.mde) database.
The "Intial Entry" form has four fields - Originator, Type of Request, Department, Comments
Six of the fields in the linked table should be populated when the Initial Entry is submitted
Date: defaulting to Date(), the four fields they entered into the form, and Status: defaulting to "OPEN"

This works for most users/computers
There are two specific computers that accept the entry, but do not populate the Date field or the Status field with the default values.
Sometimes, the two users in question get an error message when they input the Type of Request, but I don't understand that either because it's just a lookup combobox (source: type id and type). They close the error and it lets them input the type the second time they choose it, then they can finish and submit the entry.

The Windows date on the computers is set. There are no subforms or complicated structures. The *,mde files were put on their computer at the same time as everyone else's....
I'm at a loss as to what to even check

Does anyone have any ideas?

Thanks
Christine

[Wendell]

Several possibilities to look at:
- is your database split with the frontend .mde with forms, reports, queries and such on the workstations?
- how are you setting the default value - at the table level, or on the form?
- if the database is indeed split, is it an access back-end, or is it SQL Server, or Oracle or????
- if it is an access backend, do those users have full file permissions on the file and on the folder that contains the backend?

With answers to those questions, we may be able to suggest some other things to check.

[Carol W.]

Sometimes, the two users in question get an error message when they input the Type of Request

It would be helpful to know the details of the error message these two users get. That could be a big clue.