Populate one form field based on another

[jhrBanker]

I have a Form (frmCriteria) with a Combobox (cmbSelWsCd) and a Text Field (txtWsMgr).

I have a table (WS) with the following fields:
WsCd
WsDesc
WsMgr

The Combobox has WsCd & WsDesc (WsCd is bound).
When I select the WsDesc from the Combobox I want to populated the Text field txtWsMgr with the corrosponding table value.

I've tried: DLookup([WsMgr], "WS","[WsCd]=[Forms].[frmCriteria].[cmbSelWsCd]")

I've entered the following for txtWsMgr Source: SELECT WS.WsMgr FROM WS WHERE (((WS.WsCd)=[Forms].[frmCriteria].[cmbSelWsCd]));

Any suggestions?


Thanks

[AlexHedley]

You have the whole Criteria as a String so it isn't using the cbo as a variable

DLookup([WsMgr], "WS","[WsCd]=[Forms].[frmCriteria].[cmbSelWsCd]")

Change it to

DLookup([WsMgr], "WS","[WsCd]=" & [Forms].[frmCriteria].[cmbSelWsCd])

What Data Type is WsCd?

You might need to wrap the DLOOKUP criteria, combo value, in " ' " and " ' " if it is a String

[Missinglinq]

You don't really say where you're trying to do this, and the syntax varies a little, depending on that. You do it in the cmbSelWsCd_AfterUpdate event, using

If WsCd is defined as a Text Field

Me.txtWsMgr = DLookup("[WsMgr]", "WS", "[WsCd]= '" & Me.cmbSelWsCd & "'")

If WsCd is defined as a Number Field

Me.txtWsMgr = DLookup("[WsMgr]", "WS", "[WsCd]= " & Me.cmbSelWsCd)

BTW, you cannot use a Select Statement to populate a Textbox; you really have to use DLookup.

Linq ;0)>

[jhrBanker]

Yes, WsCd is a string value.
I tried: DLookup([WsMgr], "WS","'[WsCd]='" & [Forms].[frmCriteria].[cmbSelWsCd]), but still not working. Getting #Name?

[AlexHedley]

You missed the closing " ' "

Try Linq's

Me.txtWsMgr = DLookup("[WsMgr]", "WS", "[WsCd]= '" & Me.cmbSelWsCd & "'")

[jhrBanker]

Got it. Thanks so much for the help.

[Missinglinq]

Glad we could help!

Linq ;0)>