RE: Set label caption from query?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Try this

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


--
In God We Trust - Everything Else We Test


"Heather" wrote:

> 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?
.

Quantcast