Please Help!!!

bodvoc

Red Sea Pedestrian

Local time

Today, 10:34

Joined

May 4, 2003

Messages

54

• Jul 27, 2003

• #1

Hi All

As a newie... I am stuck!

From my main db form, I have created a command button that opens a very simple form with two unbound text boxes and a command button called "go", these text boxes feed a query the cirtiera, and the "go" button runs the query and opens a form showing the records found....

This works great... But.. and heres the but...

I now want to put a command button on the form thats now open, and runs this exact same query while the form is still open.. Finding new data matching the criteria... Or should it be a requery, refresh or something else .. if this is easier?? I only want to do this to stop Users going back and forth from form to form...

Thank you all in advance, Bodvoc

 

mark curtis

Registered User.

Local time

Today, 10:34

Joined

Oct 9, 2000

Messages

457

• Jul 27, 2003

• #2

why dont you do the following:

Send the users straight to a form with the two unbound text boxes and then use a subform based on the query results. You can then either clear the sub form with code or use requerycos the table will be refreshed as opposed to refresh that only refreshes the form.

 

A

AncientOne

Senior Citizen

Local time

Today, 10:34

Joined

Mar 11, 2003

Messages

464

• Jul 27, 2003

• #3

Or if you are keen on doing it your way, look up Docmd.ApplyFilter

 

bodvoc

Red Sea Pedestrian

Local time

Today, 10:34

Joined

May 4, 2003

Messages

54

• Jul 28, 2003

• #4

Thanks Guys.. will try them both to see what works best...

 

bodvoc

Red Sea Pedestrian

Local time

Today, 10:34

Joined

May 4, 2003

Messages

54

• Jul 30, 2003

• #5

Ermmmmmmmmmmmmm!

Hi Guys, and thanks for your replies...

Well tried that.. and well though it works.. its not what is needed...

I really need to get the form to recalc / refresh / requery loading the input form I created..and updating the now open details form.. Thick Users I am afraid.. they can't cope with (and neither can I at the mo!)

Any clues as to how to make this form behave like it does from the main form?? Apply filter doesn't seem to do what I expected it to.. or perhaps I have missed something... (likely)

Thanks again

Bodvoc

 

A

AncientOne

Senior Citizen

Local time

Today, 10:34

Joined

Mar 11, 2003

Messages

464

• Jul 30, 2003

• #6

You want to avoid having to make your users switch forms? They don't have to! Put a command button on your details form that hides it and sets focus back to your main form. Change your criteria there and unhide and requery your detail form. What's the objection to that?

If you don't do that, how will you change the criteria to search for different records?

 

Mile-O

Back once again...

Local time

Today, 10:34

Joined

Dec 10, 2002

Messages

11,305

• Jul 30, 2003

• #7

Looks like basically the same thread - I'll cross reference them.