How to create a Query using Form??

[Ramshan]

Hi,
I am Ram. I am a novice in MS ACCESS. Right now I have been given a work where I have to create a form that will function as a query. I am finding difficulty in creating it.
Can anyone please help me on it?

Exactly my problem is, my form contains some 7 fields like address, city, phone number etc. Here I have to create a query form, and it should function like, If I type in some street name in the Address field, it should bring all the related values from the database table.

Can someone help me out??

 

[cookiegary01]

You want to Filter a form, to my understanding.

Try this:
http://allenbrowne.com/ser-28.html

 

[Ramshan]

No that is my question. To make it simple, my question is How do one incorporate query in a form?? or how can one retrieve data from a table using a form? Thanks for the reply though.

 

[cookiegary01]

A Form is based on 1 Table or on 1 Query.

Basic steps for Tables,Queries,Forms and Reports:
1 Basis of all data = Table
2 Make relationships between Tables
3 From Table(s) you make Query/Queries to get required data
4 From 1 Table or 1 Query you make a Form
5 From 1 Table or 1 Query you create a Report

Answer to your question: "How to retrieve data from 1 Table or 1 Query on a Form":
- In design view of the Form, Select the Properties of the Form
- On the Tab "Data", select the Record Source (Table or query).

 

[rodmc]

Ramsham, didnt I give you a link to a filter a form page on her only a few days ago?????

 

[AccessBlaster]

How about "Find as you type"

 

[jdraw]

It sounds like you're trying to so a Search form.
Take a look at this free video tutorial.
http://www.datapigtechnologies.com/flashfiles/searchform.html

 

[Ramshan]

@Access Blaster and jdraw - I tried following all the steps that are provided in the video link, but its not working.
both the Clear parameters button as well as Run query button is not working.I donno why Can some one please help me on this.