Set label caption from query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table (Version) with an autonumber index field (Ref) and a memo
field (Description). I would like to display the latest entry in the memo
field in a label on a form, but can't work out how. I can make a combo box
show the information (2 columns, first hidden, Dmax to display the latest
entry) but using the up arrows you can scroll back through the table entries,
and I don't want that.
I am trying to use "Me.lblComment.Caption = ........." in the form's load
event but don't know how to continue. Do I need a query?
Unless there is some way to make a combobox act like a label?
 
Try this

Me.lblComment.Caption = dlookup("Description","Version","Ref =" &
Dmax("Ref","Version"))
 
Back
Top