Does each user have a copy of the Front End on their machine?
Controls don't appear in Form View when three conditions exist at the same time:
- The Form is Bound to a Table or Query
- There are No Records in the underlying Recordset or the Recordset cannot be accessed
- The Form cannot have New Records added
The reasons that a Bound Form cannot have New Records added include:
- AllowAdditions for the Form is set to No
- The underlying Query the Form is based on is Read Only
- User doesn't have Read and/or Write Permission for the Folder where the Data resides or there is a connection problem with the network.
- Folder the File resides in (in versions 2007/2010) not having been declared as 'Trusted'
- Form's Recordset Type is set to Snapshot
Given your post stating that nothing has been changed, if the answer to my question above is 'yes,' my guess would be that something has changed in your network and it is likely that #3 above is your problem. Do you have a network administrator, and has something changed there?
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007