Get input for parameter query from a form

RexesOperator

Registered User.
Local time
Yesterday, 19:08
Joined
Jul 15, 2006
Messages
604
I am not a programmer and I don't know VBA/VB.
I am using this as a workaround to avoid VBA functions (since I don't know them).
I can't seem to find a simple? solution to this.
I have a query that does a radial search in decimal degrees. I have created an unbound form as a dialogue box that converts degrees-minutes-seconds to decimal degrees and displays the results in a calculated text box. What I want to do is have the query take the results in the calculated text box as its parameters (along with a third parameter- distance) without prompting the user. How do I get the query to take its results from the fields on the form? I have tried Like [Forms]![frmName]![SearchValue], but I can't seem to make it work.
 
I am sorry if i get your hopes up for a reply, But i am in the same boat as you so i am gonna bump this to the top.

Thxs
 
I have looked at the other examples listed below and in several different books, but the examples are based on text boxes with character strings. My input is a trio of decimal numbers that have to be taken as ANDs.
For example 50.56789 (Latitude) AND 100.89776543 (Longitude) AND 50(radial distance). The [forms]![frmName]![SearchValue] works fine for text strings in other areas of the application, but doesn't seem to work on the numeric data type. Should the data type matter? If it does, is there another way to do this?
 

Users who are viewing this thread

Back
Top Bottom