linking form and table

[tamirka]

I have 2 fields in a form. name and last name
i have a table called names in which I have all the names and last names.
when i open the form , I need to type in the name, the last name will automatically show up in the last name field
please help asap

 

[Corticus]

tamirka,

Make a query from the names table. Open your form in design view. Set the forms record source to this query and the control source of the two controls to the name fields. In design view of the query, right click on the criteria field for 'name', select built|expression builder|open forms, and find the control on this form that will hold the name. Save and close the query.

On your form, right click on the textbox that will have the name, select build event, and enter this code:

sub txt1_afterupdate()

me.requery

end sub

with txt1 being the name of the control that will receive the name for which you want to search.

HTH,