Creating a Form that pulls up data

[Accu-Grind]

I need to create a form that when you type something into a field (lets say a name). The information related to that name from a table comes up. I don't want to create a report because I then need to add data to the form before making the report. I know this can be done because I've seen it in another access system we have. I've tried using subforms but they seem to only let me input data rather than extract.




Thank you.

[orange]

I suggest you start by creating a SELECT query against your table. Do some experimenting to see exactly what a query can do. Then you could try using the query as a recordsource for your form.

[ranman256]

Put a box for name, rename the box txtName.
the query will be:
select * from table where [name] = forms!frmFind!txtName

Save the query
a button on the form will open the query.

[Accu-Grind]

I'm confused. I have to make a query first? And where do I write ​select * from table where [name] = forms!frmFind!txtName?

[ranman256]

In the query designer.
You should get a book on the basics of Access. These are the building blocks of the whole program....tables, queries, forms.

[orange]

Do some searching -- look at Youtube MSAccess query

[rebfein]

Hello,

I have something similar that I need to create. My boss said that he wants a form where a category type can be entered into a searchable text field and to press a button; then have the search results appear as list.

The table is already ordered by category type, so how would I enter this information on a form? And would a drop down list be better than a search being that the users won't know that several minor categories are grouped?

Thank you,

Rebecca