Form with search

[La rimo]

Hello. I made a form. It's like this


(** = PICTURE)
******** First Name
******** Last Name
******** Gender
******** Age
******** blablabla
******** blablabla
blablabla
blablala


I want to create a search bar on top of the form.

It has 4 boxes, 2 buttons. firstname, lastname, gender. Search, Clear.
When I type the things I want to look for (like, males with name matt) and click search, I get a table with search results (the information form goes away).

Clicking one of the results shows the information form I described above (with the persons data who I clicked).

This has to happen inside one form (no opening/closing forms). Subforms are ok.


Does anyone have any tips? I'm a beginner and I feel like my head is going to blow.

 

[Jeanette Cunningham]

Here is a link to my favorite search form - I use this in all my apps.
http://www.allenbrowne.com/ser-62.html

 

[La rimo]

Here is a link to my favorite search form - I use this in all my apps.

Thats nice but I still don't understand how to click something on the search results and get the profile open. (without changing forms).

 

[Jeanette Cunningham]

Now it's my turn to say 'I don't understand'.
What do you mean by 'Thats nice but I still don't understand how to click something on the search results and get the profile open. (without changing forms). '

Search forms are built for searching, they are not built with data edit and entry as the main goal. I never recommend to make a search form using a form where users can do data entry and edits.

The reason is like this: Searching on choices from dropdowns will usually give several different records or rows that match those choices - then the user can double click on the textboxes in the row they want to open the data editing form for that single record.

Often the query used for the record source in a search form is not updateable (that means you can't edit the data in the search form anyway).

 

[John Big Booty]

Here's another search form, that I like to use

 

[John Big Booty]

... it does allow the user to double click on a record to allow the user to view and edit the full record.