P
Pat Dools
Hello,
I have an application in which the data entry person first enters in key
info. about a patient record (e.g., 'Patient ID' and 'Patient Initials') on a
'Patient Info.' form, then clicks on a Command Button to go to a custom
Switchboard, from which she/he can open a number of different forms to enter
in pieces of that patient's study information.
The 'Patient Info.' form remains open while the data entry person navigates
between the various study forms (e.g., Patient Eligibility, Demographics,
etc.), so that key info. about a patient record (e.g., 'Patient ID' and
'Patient Initials') can be inherited onto the form, so that the data entry
person does not have to type it in, and possibly make a mistake.
Besides the data entry text controls for the 'key fields', one can also
select an already-entered patient from a Combo Box, and click on the Command
Button to open the Switchboard so that patient's 'key fields' can be carried
over to whatever form is chosen from the Switchboard. The Combo Box looks up
to a table that stores the Patient ID/Patient Initial records that are
entered into this Patient Info. form.
What is happening is that already-entered patients are not visible in the
Combo Box until you close the Patient Info. form and re-open it. Do I just
need a bit of code behind the On-Click Event of the Command Button that saves
the record (ONLY if that record is new) to the table that these 'Patient
Info.' records are being entered into before opening the 'Switchboard'? Or,
do I just need some sort of 'Refresh' behind an Event Property of the Combo
Box so these records will be visible in the drop-down list when one clicks on
it?
Thanks.
I have an application in which the data entry person first enters in key
info. about a patient record (e.g., 'Patient ID' and 'Patient Initials') on a
'Patient Info.' form, then clicks on a Command Button to go to a custom
Switchboard, from which she/he can open a number of different forms to enter
in pieces of that patient's study information.
The 'Patient Info.' form remains open while the data entry person navigates
between the various study forms (e.g., Patient Eligibility, Demographics,
etc.), so that key info. about a patient record (e.g., 'Patient ID' and
'Patient Initials') can be inherited onto the form, so that the data entry
person does not have to type it in, and possibly make a mistake.
Besides the data entry text controls for the 'key fields', one can also
select an already-entered patient from a Combo Box, and click on the Command
Button to open the Switchboard so that patient's 'key fields' can be carried
over to whatever form is chosen from the Switchboard. The Combo Box looks up
to a table that stores the Patient ID/Patient Initial records that are
entered into this Patient Info. form.
What is happening is that already-entered patients are not visible in the
Combo Box until you close the Patient Info. form and re-open it. Do I just
need a bit of code behind the On-Click Event of the Command Button that saves
the record (ONLY if that record is new) to the table that these 'Patient
Info.' records are being entered into before opening the 'Switchboard'? Or,
do I just need some sort of 'Refresh' behind an Event Property of the Combo
Box so these records will be visible in the drop-down list when one clicks on
it?
Thanks.