Access Forms

[Vistaz]

Hi there,



I am having some difficulties with my application. Firstlly i have the form that populates all faults logged regardless of the status, the source for my form is the query Q1. On the form i had an option to allow for filtering using fault reference number for which you must enter ref number and press the button. After you pressed the button the form must refresh to show only that fault. The problem i have is that when i press the button, my Q1 is modified to include the condition but the condition is save on the query. When i close the form and re-open it again, it doesn't default back to show all the faults.

Can anyone help me out on this.

[orange]

There is a specific forum here for FORMS.

As for your issue/question, you have not told us much about your database - its purpose, its structure....
Q1 does not help the reader to understand your environment or your issue. Please post the SQL of the query (Q1).
What is the purpose of Q1? Please describe the Form, its purpose, its controls....

When you read your post, do you really think that others, unfamiliar with you, your database, your environment, your forms and your query could make any sense of it?

For reference, pretend you are in a line up at McDonalds. you turn to the person behind you. That person doesn't know you; has no idea what a database is; and has minimal familiarity with computers. In the most simplistic terms and in plain English WHAT exactly would you tell that person to describe your problem?

[Vistaz]

thanks for your response,

My query looks like:
SELECT Issues.ID, Issues.[Fault Ref], Issues.Title, Issues.Caller, Issues.[Assigned To], Issues.[Opened By], Issues.[Opened Date], Issues.Status, Issues.Category, Issues.Priority, Issues.Description, Issues.[Resolved Date], Issues.[Related Issues].Value, Issues.Comments, Issues.Attachments, Issues.App
FROM Issues;

This query is my record source for my form. In other words, the form will display all records from the database. Since the records will be huge, i've added a textbox(txtSearch) and button (cmdSearch) on my form to apply a filter. When clicking that button i want the form to show only the record that matches the Reference number that i have entered on my textbox(txtSearch).

[msoffice.vidyarthi]

are you aware of the where criteria that you can utilize in the queries, where criteria will give you the right outpu

[orange]

I suggest you review this video tutorial
http://www.datapigtechnologies.com/f...tomfilter.html

[Vistaz]

but i don't want it to filter on form load

[msoffice.vidyarthi]

It wont, attach the zipped db file which would help to review and make necessary changes

[msoffice.vidyarthi]

One turnaround is to put the table(instead of query) into the form and set the filter(coloumn=txtSearch.text), filteronload(false) properties

[Vistaz]

Please find my application on the zip folder attached.

[Vistaz]

One turnaround is to put the table(instead of query) into the form and set the filter(coloumn=txtSearch.text), filteronload(false) properties

Hi

So how the command button will trigger the form to filter?

[msoffice.vidyarthi]

Just replace the code : Me.Filter = "Issues.[Fault Ref]=" & Chr(34) & [Ref] & Chr(34)

by : Me.Filter = "ID=" & [Ref]

this will work as per requirement, no other changes are required, reply with result

[Vistaz]

Just replace the code : Me.Filter = "Issues.[Fault Ref]=" & Chr(34) & [Ref] & Chr(34)

by : Me.Filter = "ID=" & [Ref]

this will work as per requirement, no other changes are required, reply with result

Thanks it worked.

[msoffice.vidyarthi]

Thanks it worked.

Would you click on the star below my post to add to my reputation