Requery - "Want another search"

[NGFLNG1]

Hello,



I have designed a query that has a dialogue box that asks, "Enter the Section you require"--or words to that effect. Then the results are shown. But I want another dialogue box to pop up immediately after the first query that will ask, "Do you want to perform another search?". If the user chooses yes, I want the original question to pop up again.

Does anyone know how that is accomplished? Thank you in advance.

[rpeare]

Personally, I find this mechanic clunky. What you may want to try is this:

If you have a form in your database, put a combo box on that form that selects the 'section', then in the query design instead of having a prompt in the criteira for [Enter the Section you Require] you would have a reference to the field on the form like:

[forms]![formname]![fieldname]

So let's say your form name is frmSearch and the field on that form is cboSection (combo box with all the section numbers) your criteria in your query would be

[forms]![frmSearch]![cboSection]

Then when they close the query they can choose another section and not have to rely on typing it in correctly, they will be picking from a pre-defined list.

[NGFLNG1]

I don't have a form made for that purpose. I guess I should have told you I just want to pull the names of the people in a particular Section.

So I created a "blank" form with a combo box, but that was the only thing I put on it. How do I get the names to show up, along with the section (so I can be sure they are in the Section ordered up)?

Should I start from a "blank" form, use the wizard, or some other option?

Thx again!

[orange]

You may get some ideas from this article and code by Allen Browne.

[June7]

Also review:

http://datapigtechnologies.com/flash...combobox3.html

http://datapigtechnologies.com/flash...combobox2.html

[NGFLNG1]

Okay, my search form now works using Mr. Allen's basic form. I changed some of the search criteria in the "event procedure" behind the "Filter" button and it worked beautifully.


However, I added a label to show all of the names you can search on when searching for the particular "Section". Two of them are named: S&S, P&C. Notice the commonality of the ampersand. The problem is the form just shows SS or P&C (C is underlined). However the user must search for "S&S" vice SS or there will be no results. I entered the data for the label in the "Caption" property of the label.

Is there a way around this issue?

Thx again!

[rpeare]

the & on a control will give you the means to 'click' that button with a keystroke (alt plus the letter) so if you have a button where the caption is &Add you can hit alt-a and simulate the button click. Your control to provide the criteria for the search should be a text box, combo box or list box, not a label or control (button) and the ampersand should show up just fine in text boxes etc.

[June7]

Double the & to force it to be normal text in label or button caption.

However, as rpeare says, controls for inputting filter criteria should be UNBOUND data controls, not labels. How are you using a label to show all the names? And how is label used to construct filter criteria string?

[NGFLNG1]

My label is just off to the side. I still have the unbound control that Mr. Allen used in his sample DB for the search criteria.

So I took June7's advice and doubled the ampersand and now the label displays correctly. So thank you both.

I need to mark this thread "SOLVED".

[June7]

Thread Tools dropdown above first post.

[NGFLNG1]

Thread tools only give the option to mark as unsolved. I do not see an option to mark as "solved". Threre are a couple of other options, but not related.

[June7]

That's because I already marked thread as solved.