data update issue

[ptquan]

Hi there,

I have two table tbjJobInfo which contents AGENT field linked (look up) to tblSupplier. An input form created from these two tables.

While enter info, user has to enter new Supplier info in tblSupplier for the NEW name. The update take abit long time to be updated in the Combo box in the form. User has to wait or close then open Access for several times to get new info updated to the input form.

Tables are on backend and located on the server. Form executed from frontend file located on the WS.

How can I shorten this update time? Immediately update is preferable.

Thanks to advice.

Quan

 

[jdraw]

???User has to wait or close then open Access for several times to get new info updated to the input form.???

This is NOT common.

Does each of the multiple users have their own copy of the FE on their PC?

It sounds like a coding/design issue.

 

[ptquan]

Thanks for your feedback, Jdraw.

Yes, each user has there own FE on their PC.

//Quan