Combobox select value from txt field

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

 

[Alex Dybenko]

hi,
best approach - is to query underlying table to get ClientID and assign it
to combo:

me.cboClient=dfirst("ClientID","MyTable","Debnr='" & me.Debnr & "'")


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

 

[Frank]

Unfortunately, this doesn't seems to work with guid's (ClientID)
Any other helpfull tips...
Thanx

 

[Frank]

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?

 

[Alex Dybenko]

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