n3ox3ro
Last Activity: Aug 28 '07, 12:51 PM
Joined: Jun 25 '07
Location:
-
Enter Parameter Values
If im using an "enter parameter values" box in a query to find information in a table and if you type in a value that doesnt exist how do you stop if from displaying a blank screen on your form?? -
SQL-VB Enter Parameter Value Issue
For my visual Basic code i have...
Private Sub Command459_Clic k()
On Error Resume Next
DoCmd.OpenForm "view_Obs", acNormal, "ByObsNumbe r"
End Sub
and for my 'ByObsNumber' querry i have ...
SELECT main.*, main.ID
FROM main
WHERE (((main.ID)=[Type in Observation Number]))
the issue come in when if it is pulling a record from...
No activity results to display