Questions about memo field and buttons

  • Thread starter Thread starter King Kaos
  • Start date Start date
K

King Kaos

I'm very new at using access, I'm trying to do this

I want to have a memo field called medication. Then I would like to put
push buttons at the sides with the names of common meds, like a button for
Lexapro, Xanax, etc... When I push the button I want that to place the name
of that Medication in the memo field. e.g. I hit Lexapro and it's places
"Lexapro, " in the memo field. Then hit the Xanax button and have "Lexapro,
Xanax," etc.. I don't know how to program the button to due this. Can any
one help

Thanks, Keith
 
This is the kind of event procedure that will add another value to the end
of your memo field:

Private Sub cmdAddMed_Click()
Me.MyMemo = Me.MyMemo + ", " & "Lexapro"
End Sub

Is there any chance we could encourage you to do it a different way?
Consider creating another table with fields like this:
PatientID foreign key to your patient table.
MedID foreign key to your medications table.
Dosage quantity administered.
AdminDate date and time administered to this patient.
StaffID foreign key to your staff table (who administered).

You would then create a subform on your patient form. Instead of just
tacking the med. onto the memo field, the user can enter another row in the
subform each time a medication is administered, and you can query it much
more powerfully.
 
Back
Top