Form not showing added record by another user

[trident]

I have created a database wherein other people can use simultaneously. I works great that we can use it, however, I have encountered several problems regarding the data.

1. When staff1 enters a data in a form, he clicks a button, which saves and refresh the data table. A Serial Number counter is updated which is seen, this Serial Number is a unique number.
2. When staff2 enters the same form, the form is automatically updated, however, the data that was entered by Staff1 cannot be seen, but, the unique serial number is updated.

can you please explain why is this happening. As this database is heavily used, and this form is the data gatherer.



Thank you in advance.

Trident

[ranman256]

It's possible that user2 would need a refresh button to see user1's data.
i don't see why user2 needs to see this that soon. But if they do, a refresh will show it.

[trident]

Thanks for the enlightenment, however, there lies the problem, I have set up the save button so that it always refresh the form and database with the below event embedded macro:

RunMenuCommand
Command SaveRecord
RunMenuCommand
Command Refresh
GotoRecord
Object Type Form
Object Name FormName
Record Last

With this event procedure, is not that the data should be immediately seen by User1 or viceversa?

[pbaldy]

I don't use macros, but is requery an option rather than refresh? Also, if the form is in data entry mode it will not show records entered by other users.

[Missinglinq]

1. When staff1 enters a data in a form, he clicks a button, which saves and refresh the data table. A Serial Number counter is updated which is seen, this Serial Number is a unique number.

2. When staff2 enters the same form, the form is automatically updated, however, the data that was entered by Staff1 cannot be seen, but, the unique serial number is updated.

Three things:

Refresh does nothing to the data Table...it refreshes the Form! The Table is updated ('refreshed,' in the normal sense of the word) when a Record is saved.

Refresh doesn't show New Records or reflect Deleted Records...you need Requery for that, as Paul suggested. Refresh, on the Form used by staff1, only shows changes made to Records that existed when that Form was last Loaded/Requeried.

Doing Refresh or Requery, using the Save button, on the Form used by staff1, will do nothing for the Form being used by staff2! In order for either to effect a change for a given copy of a Form, that copy of the Form has to be Refreshed/Requeried.

Linq ;0)>