Combobox select value from txt field

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I'm looking for and can't find a way to select a item form a combobox when a
txt field is changed.
The other way around is me.Debnr = me.cboClient.column(2)
The content of the combobox is
ClientID(hidden), CorpName, Debnr

So when I fill-in a Debnr in the text field, on the event afterupdate the
combobox should display the corresponding CorpName in the combobox.

Can anyone help me with a vba code?
 
Unfortunately, this doesn't seems to work with guid's (ClientID)
Any other helpfull tips...
Thanx
 
Now i'm getting the result:

?DLookup("Client_ID", "CLIENTS", "DEBNR = 55514")
????????

But when I query a field that isn't a guid, for example a text field it
works fine.
?DLookup("CorpName", "CLIENTS", "DEBNR = 55514")
My Company

Why am I getting ?????? as a result when I query a guid?
 
Hi,
try to open recordset on "Select Client_ID & '' From CLIENTS Where DEBNR =
55514"
so converting GUID to string

Actually i have long time ago used GUIDs, but there are some ways to convert
guids to string and back, just try to google for it

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 
Back
Top