A
Andre C
I have a form into which community nurses enter details of patient
contacts.
On this form (based around a table called VISITS) I have two
comboboxes. Both draw their data from the same table (CCN) which are
the staff members. The first combo box is used to identify whose
nurse a patient belongs to. The second combobox is asking who is
entering the current record. This is then stored in a field in VISIT.
9 times out of 10 the person will be the same as combobox1. Therfore I
want combobox2 to show the value of combobox1 as soon as that is
changed with the person being then able to change this if they are not
that person. Naturally I want teh value in combobox2 stored in the
field before the record is closed.
I am struggling with this and can find no help on google.
Andre
contacts.
On this form (based around a table called VISITS) I have two
comboboxes. Both draw their data from the same table (CCN) which are
the staff members. The first combo box is used to identify whose
nurse a patient belongs to. The second combobox is asking who is
entering the current record. This is then stored in a field in VISIT.
9 times out of 10 the person will be the same as combobox1. Therfore I
want combobox2 to show the value of combobox1 as soon as that is
changed with the person being then able to change this if they are not
that person. Naturally I want teh value in combobox2 stored in the
field before the record is closed.
I am struggling with this and can find no help on google.
Andre