>Hi --
>
>I have a search form I created for users to select values and find a specific political office. My search form consists of 6 combo boxes:
>
>country
>state
>county
>locality
>district
>office title
>
>My aim is to place a cmd button on this form which fires a form with a grid, that provides information on the specific office the user selected. The trick is having the cmd button call the specific office.
>
>A.
>I created a pview (based on my offices table) that has the following WHERE statement:
>
>WHERE "myview".city = ?lnlocality AND
>"myview".district = ?lndetail AND
>"myview".officetitle = ?lntitle
>
>B.
>I created a form to hold this new view, and placed the view on the form canvas.
>
>C. I created a method called "requeryview" at the form level to set my variables, as follows:
>
>lnlocality = rowsource of locality combo
>lndetail = rowsource of district combo
>lntitle = rowsource of officetitle combo
>
>I then requeried view in the INIT
>
>
>** I got the view to fire, but it pulls all the records in the view, not just the specific record that matches the criteria the user selected in the last three combo boxes. I somehow need to indicate for my view to only look at the CURRENT VALUE in the last three combos, and pull that specific office.
>
>However, I don't know the correct code to do that. How do I tell the pview to only pull the selected value of the three combo boxes (locality, district, and office title)???
>
>
>thanks for any assistance
>
>jason
Why not do it the easy way. Get QBF Builder from
www.classycomponents.com and let it build the query for you. It will also allow you to use the same form for data entry and query.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer