searching

[Guest]

i have a table full of quotes. each row contains a new quote. When i select
view quotes from my switchboard i want a new form to open which asks me which
customername i want to display, then when i select the customer name i want
it to search all rows for matching data then display all rows found. then i
can select which quote to view

Any one help

 

[Guest]

Try using query by form: http://support.microsoft.com/kb/209645/
That will tell you how to do it. In the query, you can add any fields
that you want to view. If you want to use a combo box to look up the
customer's name then follow the same directions and when finished right click
on the text box, click change to, combo box. Then go to the properties of
the control and set the row source property to the information you need.

You will see the results in datasheet view because it is a query, but you
can create a form based on that query. If you make the form view "continuous
forms" then you can view all selections. You can then set it up where if you
select one it shows info.

 

[Guest]

I have done what you have surgested and all works ok.

how do i select one and it shows all info??

 

[Guest]

All Is Ok, I've worked it out.

Many Thanks

I have done what you have surgested and all works ok.

how do i select one and it shows all info??