how do i update data instantly between two front end databases

[DiGamer]

I have two front end data bases linked to a single database, I want when I enter patient name in the first front end to be instantly updated to the patient name field in the second front end...

I can only think of on timer property in both front end forms to requery every 30sec....which makes the screen flashes every 30 sec.



i am out of ideas need help plz thanks in advance

[June7]

The frontends are linking to the same data? Refresh/requery is the only way to make data show up. Access default refresh interval is 60 seconds. I have multi-user database and entries by one user show in other user's frontend after default refresh, no 'screen flash'.

[DiGamer]

thank you for the speedy reply

But let me explain more

It is medical database, the first front end form hold the patient name and the reservation date list, the second front end form hold a combo box which populates the names of patients and reservation date in the first fe form

what does not happen is when I add a new patient or new reservation for existing patient in the first fe form it is not automatically populated in the second fe form combo box. I have to either close and reopen the form for instant update or use a command button with requery\refresh command to update the combo box and both are inconvenient for users because simply we are not adding names or reservations constantly so they never know when they should update the combo box list

[DiGamer]

thanks in advance

[June7]

That's different from just refreshing a form's RecordSource.

A combobox must be Requeried. Yes, the form Timer event could be used. Or maybe just the combobox GotFocus or Enter or Click event or maybe all three.

[DiGamer]

is there a solution on the table level ,that after the table is updated the combo box automatically reque

[June7]

I suppose if working directly with tables and Lookup is set in table, the RowSource would automatically refresh as records are added to the lookup table. But I never set Lookup in table and users do not work directly with tables and queries.

Regardless, combobox on form must be requeried.

[DiGamer]

the only thing I think of now is on time event of the main form to set focus to combo box and requery

[June7]

Can requery combobox without setting focus to it. I've never used timer event. I have read it can be a process hog. I would use the other events.