Recent content by Krikkit

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

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")

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

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...

Keep the combo box, but instead of selecting the value, type it into the combo and it should auto-correct you (if you've not switched that property off).

Hi guys, I know these threads are spam-traps, but I thought I'd say hi anyway. Thanks to you guys, you really saved me from a fate worse than death with my project. :)