searching for a record in access
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 ?
Re: searching for a record in access
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