Forms ?

[Khalil Handal]

Hi,
I have information about 100 persons, data is entered using a form, (name,
address, phone, Birth date.....)
I need an other form to SEE data about a certain person by typing his name
(for example)
to be more clear:
The fields in this form will be empty.
I am allowed to type the name_field
when I press ENTER all the other in formation about that person will be seen
on the screen.

Khalil Handal

 

[Guest]

Sounds like you need the 'Filter By Form' function.

It's too long a job to explain here, but if you check out the online
help,for 'Filter by form' you should find something alternatively a search on
google for "Filter By Form" +Access yielded quite a few interesting articles.

HTH

Neil
www.nwarwick.co.uk

 

[John Vinson]

Hi,
I have information about 100 persons, data is entered using a form, (name,
address, phone, Birth date.....)
I need an other form to SEE data about a certain person by typing his name
(for example)
to be more clear:
The fields in this form will be empty.
I am allowed to type the name_field
when I press ENTER all the other in formation about that person will be seen
on the screen.

Khalil Handal

You can actually do this on the SAME FORM (or, if you insist, on
another form). A form's just a window - you're entering the data
*through* the form into the table, not into the form.

Create a Query using the table of people. Include the unique primary
key PersonID (and if you don't have such a field YOU REALLY REALLY
NEED ONE!) and the name - probably something like

SELECT PersonID, [LastName] & ", " & [FirstName], Address
FROM peopletable
ORDER BY LastName, FirstName;

so that you can deal with multiple people who happen to have the same
name. Save this Query.

Now, open your Form (or create a new form based on the People table);
click the magic wand icon on the Toolbox so it's selected; and add a
new Combo Box to the form. Choose the option "Use this combo box to
find a record", and base it on the Query you created.

This will let the user *PICK* a name that exists in the table
(preventing misspelling problems like searching for me as John
Vincent, or for you as Khalil Handel) and jump directly to that
record.

John W. Vinson[MVP]