Populates

[Chi]

Hi,

I would like to be able to auto populate the SCORE field value from INITIAL
form to
RADIOLOGY form inder textbox "VAS". Both forms have the same Control Source
from "PATIENT" table. Therefore, The CLINICNUMBER field is in both forms.

Ex: Is there a way I can populate the score value for record 10, clinic
number is 12122, at INITIAL form to be appeared on the textbox named VAS on
the RADIOLOGY form with the same ClinicNumber 12122?
Please help
Thank you so much!
Chi

 

[Mr. B]

If two or more forms have the same bound field and that field is updated on
one form, that chang must first be committed (saved) to the table, then you
must requery the other form(s) and the new value will be displayed.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm