Use VBA to get one record from a table

[jhomeyer]

I want to use VBA to get the data from one record in a table and store the results in variable that I can use throughout the rest of the application. I have an unbound text box where the user enters the text I want to select on. I tried using the docmd.runsql to select the record but it only allows action sql statements, not simple selects. I tried using the findrecord but couldn't figure it out either. The form only has one text box and a command button. If the user enters text that fails in the where clause of the sql select, I'll give them a second chance and then exit them from the application.

 

[Bodisathva]

check out the DLookup function