Need some help with a form and a query.

[swright]

Hi, didnt know where to put it so I put it in General.

I am a complete novice at Access so this might sound really stupid but....

I've got a table with Parameters on, so when i double click the table I get a box coming up saying 'Longatude' (which i type in then click ok) and I then i get a box saying 'Latitude' (type that in and click ok) then i get a box saying search term (which is my courses)

(Because basically I have a table with all the courses which 5 colleges do, and what this will hopefully do is when i type the Longitude and Latitude of the location im at then the course i want to do (search term) It should bring back the colleges which do the course in distance order,

But I have a form which I want to type the Longitude and Latitude and the course and click search, Insted of clicking on the table and the Parameters appearing.

This might make no seance what so ever, but if anyone knows what I'm on about then thank you!

 

[spoole]

This is the basics, I dont have time to explain everything at the moment but:


In basic terms you need to base a query on the data that you type in form. The form will include 3 unbound text boxes for you to type in and one button that will run the query. To get the data from the form to the query you need to reference the form and text box name in the query itself.