Determining Field Value for Selected Record

  • Thread starter Thread starter Kim P
  • Start date Start date
K

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...
 
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
 
Back
Top