Microsoft Forms....

[wazdaman]

I need help with the records stuff on access...

Hey,

i got a form patient information and in that form there is an unbound text box, when you click the box a form opens showing the medical history.

i can easily do this but i have come across a problem.

on the patient info form i want to go to patient id P003 and then when i click the unbound text box i want it to open up the form showing the medical history of patient id p003 not p001 the first field.

does anyone knw how to do this and could some one help me..

 

[wazdaman]

all the information is in one table called tblPatientInformation...

 

[wazdaman]

heeeeeeeeeeeellllllllllllllllllllllllllllllloooooooooooooooooo

 

[Laurentech]

In the onclick event of your unbound textbox launch your Medical History form with the following code:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmMedicalHistory"

stLinkCriteria = "[PatientID]=" & "'" & Me![PatientID] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

 

[wazdaman]

Thanks For your idea but i have already accomplished it in forms of a sub form.

 

[Laurentech]

There's always several ways to accomplish a task - glad you found one that works for you!

Larry