Navigation buttons and prompt to close result screen

[tpck1]

I'm a newbie to access and need some help.First I want to get rid of the navigation buttons at the bottome on the results window when running a select query.Then I want to be able to prompt to user in a pop-up after query is ran if they want to run query again or exit after.Here is the select query that I have started:

SELECT SO_Branch.BRANCH, SO_Branch.REGION, SO_Branch.PO_NAME, SO_Branch.STATE
FROM SO_Branch
WHERE (((SO_Branch.ZIP)=[Enter Zip Code]));

Thanks in advance and any help is appreciated.

 

[PHV]

Why not following the wizard to build a form based on your query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tpck1]

I don't want to use the wizard to create the form because I already have the form created and there is only one command button on the form--the command button runs the query. I just want to be able to prompt the user if they want to continue to search or exit after the result screen for the query pops up.

 

[belovedcej]

Maybetrying it a different way would work better.

Create a new form and display the query results in it as a subform in a datasheet view. Have your command button open that form instead of running the query.

In the properties dialog of the new form tell it not to include navigation buttons.

Then on the new form put in two buttons - one that says "run search again" and one that says "exit."

On the on-click of the "run search again" button, put Me.Requery

On the Exit button put DoCmd.Close