combo boxe

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table of appointments with dates and time in them, and 2 combo boxes
with memo field.
Doctors combo box

DR Richards
DR David
DR Marie

Patient combo box
Smith
Brown
Blue

What I need to do is
Once I select the Patient and DR for the combo it should add it to memo field

Memo field should be like this

1- Brown WITH DR Richards
2- Blue WITH DR Marie

have a nice day
 
I have a table of appointments with dates and time in them, and 2 combo boxes
with memo field.
Doctors combo box

DR Richards
DR David
DR Marie

Patient combo box
Smith
Brown
Blue

What I need to do is
Once I select the Patient and DR for the combo it should add it to memo field

Memo field should be like this

1- Brown WITH DR Richards
2- Blue WITH DR Marie

have a nice day
Click to expand...

You *could* do this with the AfterUpdate events of the two combo
boxes... but I'd really recommend that you reconsider this design. It
looks like you're storing a list in the Memo field. A Memo is best for
storing free-form narrative; if you really want a consecutive list of
dates, doctors, and patients, you should really consider having a
TABLE with fields for the date, DoctorID, and PatientID (and perhaps a
Long Integer field that you'ld fill with a sequential number).

This table can be filled, edited and viewed using a Subform.

Will there be other (narrative) text in the memo field? Or do you have
some particular reason to violate the principle that fields should be
"atomic" in this case?

John W. Vinson[MVP]
 
I use the evens but it clear the previuse slected one. by the way i have the
table for both doctors, and patients.

I don't know how to upload my data here to have a look at it.
 
I use the evens but it clear the previuse slected one. by the way i have the
table for both doctors, and patients.

I don't know how to upload my data here to have a look at it.
Click to expand...

Open the VBA module that you're using (you say "I use the evens" -
events?) and copy and paste the VBA code to a message here.

You have not answered my question about the wisdom (or unwisdom) of
storing multiple data items in a memo field. I still think it is a BAD
IDEA.

John W. Vinson[MVP]
 
Back
Top