Enter Parameter Value error handling

[PeakH]

I've got a button to run a query that requires a parameter value (4-digit retail product number). If there is an error (someone enters a wrong number that doesn't exist), I have it set to open a message saying "Please enter a valid number".
The problem is that this message comes up for every error. Right now the most common error is that someone presses the button and then decides that they didn't want to run the query and so just closes the parameter value window.
Is there a way to differentiate between these? Or cancel the event if the parameter window is closed?

[ranman256]

use a form. On the form put a combo box with all existing prod#s.
and a button to execute.
The query looks at this as the param.
(i.e.: select * from table where [prod]=forms!myForm!cboProdNum)

1, they cannot pick a wrong product
2. they can click / or not click the button to open the query

[PeakH]

I'm having a bit of trouble with the query.
So the main problem is that there are copies of the exact same button, one on a form and two on reports. This is what I have so far, but nothing is being returned:

SELECT Right([RetailNum],4) AS Retail, [tblOrderDetails].ConfNum
FROM [tblOrderDetails]
WHERE ((([tblOrderDetails].ConfNum)=GetValue()));

The Get Value which I use throughout the database function is as follows:

Public Function GetValue()
    If CurrentProject.AllForms("frmOrderConf").IsLoaded = True Then
        GetValue = Forms![frmOrderConf]![ConfNum]
    ElseIf CurrentProject.AllForms("frmOrderList").IsLoaded = True Then
            GetValue = Forms![frmOrderList]![ConfNum]
    ElseIf CurrentProject.AllReports("rptSampleOrderConf").IsLoaded = True Then
            GetValue = Reports![rptSampleOrderConf]![ConfNum]
    ElseIf CurrentProject.AllReports("rptOrderConfPS1").IsLoaded = True Then
            GetValue = Reports![rptOrderConfPS1]![ConfNum]
    Else
        GetValue = InputBox("Enter Confirmation Number")
    End If


End Function

The button is currently on "rptOrderConfPS1", "rptSampleOrderConf", and "frmOrderConf". I'm testing it out with "rptOrderConfPS1" and the list comes up empty even though there should be a list of 15 or so.

[PeakH]

If I take out the GetValue criteria, I get a long list with all possible retail numbers and the ConfNum they're associated with. If I copy and paste a ConfNum from the query results list and put it in the criteria for ConfNum, the list comes up empty...

[PeakH]

Oh, nevermind. The ConfNum is calculated off of the table primary key autonumber, so I just used getvalue() and reversed the calculation so that it would equal the primary key value. Not sure why this worked since I'm not using the primary key in the query.

[PeakH]

Okay, whole new form works perfectly.
Just what I needed!
Thanks for the idea!