Display Text Field from ComboBox 1

[thehorse]

Search is disabled, so I'm posting this question:

I want to display data in a text field on a form based on a selection in a combo box. I get it to work with a list box, but not with a text box. Here's what I have:

Form name: frm_OfficeReport

ComboBox: cbffice; TextBox: txt_officevalue

cbffice is populated from a Group By in a query called qry_OfficeCreate

txt_officevalue should use cbffice to populate from a query called Office Value (contains two columns: office and a sum expression named Sum$)

In cbffice_AfterUpdate, I add:

txt_officevalue = DLookup("[Sum$]", "Office Value", "Office =" & Forms!frm_OfficeReport!cbffice)

This doesn't work, but I think it's the syntax of dlookup. Thanks in advance for the help.

 

[PHV]

txt_officevalue = DLookup("[Sum$]", "[Office Value]", "Office='" & Me!cbffice & "'")
If Office is defined as numeric get rid of the single quotes.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[thehorse]

PH: Thanks, Works well.

Can you briefly explain two things?
1. Why the single quotes and the second ampersand?
2. Me. and Me!

 

[Bobnz]

single quotes for text fields.
hash for dates.

ampersand is concatenation.

Me. is for referencing properties of the form.
"me.visible=false"
me! is for referencing controls or subforms on form.
"me!txtuser_ID"

think this is right, someone will correct if its not.

B