Get Specific Value from a Table and Copy it to a Textfield of a Report

[kismet]

Hi. I am a fairly new Access user so I am still pretty much in the dark. How can I get the value in a specific cell from a table(Table A) and copy it to a text field in my report(Report 1)?

I have some knowledge of SQL- can I use this in my problem?
(SELECT tblImmunization.dateAdministered
FROM tbl.Immunization
WHERE tblImmunization.PatientID = *value*
AND tblImmunization.Vaccine = *value*; )

For example: Get the administration date given the patient ID and vaccine (all from Table A) and put this date in a particular text field of the immunization certificate (Report 1).

Is there a feature in Access I can use to be able to do this copying or can I only do this with some VB coding? If so, how do I do/code it?

Thank you very much for your patience with me. =)

 

[hermanlaksko]

Hi

You could try a Dlookup statement I think that it could solve your problem.
Type Dlookup in your code and press F1 to get the correct syntax.

Rgds Herman