Determining Field Value for Selected Record

[Kim P]

I'm new to Access, have very little experience with
understanding referencing fields.

I have a form that is continuous display. I want to look
up information based on a field in the selected record.

How do I pull the value of a particular field for the
active/selected record?

Thankyou so much in advance...

 

[Allen Browne]

Just refer to the name of the control on the form to get the value in the
selected record.

For example, if you open the Immediate window (Ctrl+G) this will give you
the value of the field called Amount on the form called Invoice in the
current record:
? Forms!Invoice!Amount