Msgbox From query access

Question

I have an access form that contains an Id field.Once a user enters the Id , i want to run a query on the after update event to get the patients history field and display it as a msg box.

The query is as follows :

"Select Patients.[Patient History] From Patients Where Patients.ID = " & Me.PatientID

How can i do this?

thank you

See this question and answer: stackoverflow.com/questions/23992226/… — tlemaster
– tlemaster, Commented Dec 18, 2016 at 18:00

Gustav · Accepted Answer · 2016-12-18 18:33:55Z

1

You can use DLookup in a one-liner:

MsgBox Nz(DLookup("[Patient History]", "Patients", "ID = " & Me!PatientID.Value & "")), vbInformation + vbOkOnly, "Patient History"

answered Dec 18, 2016 at 18:33

Gustav

56.4k7 gold badges33 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Msgbox From query access

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related