searching for records through forms

[George_E]

searching for records with use of forms

Hey guys,

After browsing the internet for a while in search of a solution and flicking through numerous books, I thought you guys would be my best bet.

The situation is I have a form with a textbox and a search button. The user enters an integer into the textbox and clicks on the search button, and the contents of the record are retrieved into the below textboxes.

How could I do this? I have found a solution but it has extensive vba code and Im not too comfortable with that yet

Is there any useful links you guys could direct me to or know of any ways I could do this without having to program away?

Thankyou in advanced

George

 

[John Big Booty]

Firstly welcome to the forum.

Perhaps this Search tool is the sort of thing you are looking for?

 

[George_E]

Hello John, thanks for the welcome, I will take a look and get back to you guys

 

[gemma-the-husky]

instead of that - as a starting point just click in any field. and then click the binocular icon (or edit/find - or just ctrl-F)

does that give you what you want?

 

[George_E]

instead of that - as a starting point just click in any field. and then click the binocular icon (or edit/find - or just ctrl-F)

does that give you what you want?

Hey Gemma, thanks for your response, it doesnt really as the form only has textboxes and a button, by using the ctrl + f function, it wont find anything as there is no data in the form for it to find

 

[gemma-the-husky]

a form is normally linked to a data table (a bound form)

so you can click IN any text box, and search for relevant data in that field - in which case access will bring up the record relating to the successful search.

isnt that what you are trying to do?

 

[George_E]

a form is normally linked to a data table (a bound form)

so you can click IN any text box, and search for relevant data in that field - in which case access will bring up the record relating to the successful search.

isnt that what you are trying to do?

Thanks again for your response I know its going to pay off soon, yes thats exactly what I want to do. Enter a number in a textbox, click on search and the record is retrieved into the below textboxes

 

[George_E]

Hey guys, I finally managed for figure it out.

The Search Form
-I set the record source to the table with the data I wanted to retrieve
-The textbox where the user enters the record number is set to unbound

What happens is the user enters the number into the textbox and clicks on the search button. The search button just simply opens the results page.

The Results Form
-This form is linked to the query.

The Query
- SELECT tblIssues.[Reference], tblIssues.Title, tblIssues.Owner, *
FROM tblIssues
WHERE (((tblIssues.[Reference])=[Forms]![searchForm]![ref]) AND ((tblIssues.Title) Like "*") AND ((tblIssues.Owner) Like "*"));
Basically what happens here is the query retrieves the data from the textbox in the search form and retrieves all the data regarding that reference number in the results form.

Thanks for your help anyway guys.........I said we'll get there in the end