query cancel when opening a form

M

Mark

Hi,

I have a form that when opened from the switchboard... a
query asks the user to enter their employee ID. (The
form's record source is based off of an table, but I have
a combo box that is filled with data from a query) The
problem I am having is: When the form is opened and the
query (message box) asks the user to enter their employee
ID... there are two buttons to select from... one is "ok"
and the other is "cancel"... if the user selects "cancel"
the form is still opened with no data being filled... I
would like the form not to open if the cancel button is
selected. How can I get this working? Thanks!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crating User Form to Add Names 1
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Open model popup befor form open 0
Request Form - Alert Team Member 0
Adding data to MS Access from csv file 0
Need Help... 5
Can I save a sql statement generated by a search form? 1
Open a form from a combobox on the switchboard based on a field inthe subform 1

Top