Unbound form

[Kelly]

I have an unbound form where I would like the user to be
able to type a last name and search the lastname field of
a customer table and return all of the related fields.
Is there an easy way to do this -- or does it require vba
or sql? Thanks

 

[Guest]

-----Original Message-----
I have an unbound form where I would like the user to be
able to type a last name and search the lastname field of
a customer table and return all of the related fields.
Is there an easy way to do this -- or does it require vba
or sql? Thanks
.

 

[Bob]

You can just use an unbound combobox on the form that
feeds your customer table. Use the wizard to create the
combobox selecting LastName and tell it that you want to
look up a record based on the choice in the combobox.