searching for a record in access

[otniel]

Hello!
I'm working with Access XP and i have 2 forms with some unbounded textboxes.
I'm trying to write a textbox.lostfocus event procedure.
The idea is that when the textbox loses focus, i need to locate in one of the tables a specific record that matches the textbox.value and open the other form with all the fields of the found record.

How should I do it ?

[DKenny]

Use the following SQL synthax

SELECT whatever field you need FROM yourtable WHERE criteriafield = textbox.value


criteriafield should be the name of the field that is used to populate your textbox