Selecting Values from a value in a form

[Krikkit]

Right.
What I want to do is use a value obtained in the form (obtained from a list-box selection) to select a record in a table, then return one of the fields to a text-box on the form.
All the values coming from the list-box are unique, and the value returned is a simple integer.

Is there any way to do this reasonably simply?

 

[KeithG]

Yes you can use the Dlookup function to do this

 

[Krikkit]

Yes you can use the Dlookup function to do this

Enough of a Leg-end to be a foot. Cheers for that.

 

[Krikkit]

Got problems. Can anyone spot the flaw with this?
Just 2 textboxes and a button, linking to a table. Gives me a blank value.

Text45.Value = DLookup("[ID]", "test", "[Test 2] = Text50.Text")

 

[mdow]

me.Text45 = DLookup("[ID]", "test", "[Test 2] = " & me.Text50)

 

[Krikkit]

Thanks, but now I get run-time error 2001. Copied your code exactly, and nothing else is going on. Any ideas?