how to set textbox to values from query

[kassem]

Hi,

I have a form called Accounts with two textbox with the fields Fname and Lname. I run a query of some sort and I have record left with the columns F_name and L_name, Once i run the query how can i set the textbox values to the according values. ie. Fname=F_name and Lname=L_name.

[ranman256]

The form must be bound to the query. The EASIEST way is to open the query then click AUTO FORM button. All fields will be mapped to the text boxes.