Hi guys,

I was given a task to make an application that will enter/monitor job assignments of our technical staff on a daily basis (roughly 15-30 assignment per day), so I created a table which has all the fields and it worked well.

So after the dressing up the database, I split the table and saved it on our server, copied a FE on workstations but the data is not refreshing the way it supposed to be, what I want is whenever a user accessed the application data will be refreshed on diff. workstation in real time.

Can someone point a link on the forum regarding my problem or can someone help me to solved this problem from ground up?

Thanks in advance.

Jeff

Hi Jeff,

When you say "the data is not refreshing the way it is supposed to be", what do you mean by this.

Does it mean that you have to close the form displaying the info and then reopen it before it shows what you want? or

The record being updated / changed does not show on other PCs until that record (form) has been closed?

Can you elaberate a little.

Garry

Hi Zigzag,

I need to close the form and then reopen it again before I see the updates on the table, I tried making command buttons for "Refresh/Re-Query etc. etc." but I cant figure out how to refresh the table in run-time.

Also can you show me how to do the split thing from scratch maybe I am lost on this one.

Thanks a lot.

try

me.refresh

Garry

Hi Garry,

Still the form doesnt refresh, any more alternatives?

Thanks for your patience.

Me.Requery will requery the underlying recordset of the form. You can put that into the form's On Current event, or a button for the user to press when they want to, if you have many updates happening across users.

Refresh will only display changes made to the already existing recordset. So, additions will not show up.

I suspect you would want a requery rather than a refresh. Also, it's probably not going to happen automatically, though you could play with the settings in Tools/Options on the Advanced tab. My guess by the sound of it is that you'll want to do a requery in the timer event of the relevant form.

My apologies,

Me.Requery is the way to go, I must have been having a blonde moment.

Garry