Binding label with single value query

[gaju_3112]

I want to bind label control or textbox control with query returning single value. How can I achieve it? My query returns single value.

 

[Guus2005]

Bound form scenario: Use the On Current event of the form. populate the label.caption
UnBound form scenario: label.caption = dlookup(..,..,..) or use a recordset.

 

[gaju_3112]

Can you describe it in detail. What statement should I use in Current event and what will be the paramemeters for dlookup function?

 

[Guus2005]

the parameters for dlookup can be found when you press F1!

in the on current event:

label.caption = me.<fieldname>

 

[boblarson]

Since I remember how hard it was for me to get my arms around the DLookup syntax (even looking at the help file) I will try to help by being more explicit:

If your query already returns a single value then you don't need the criteria part of the DLookup, so it will be modified to look like this:

Me.YourLabelNameHere.Caption = DLookup("[YourFieldInYourQuery]", "YourQueryNameHere")

 

[gaju_3112]

Boblarson! It's second time you solved my problem! Very thanx to you!