search form

[riddicule123]

hi all i need help with access 2007,

im trying to create a search form where i want it to do the following,

i chose a form i want to search using a combo box
i then type the data that i want to search for in a text box e.g post code
i then click search
the search box then opens the selected form and brings up the reord with the information from the text box


i need to know if there is some vba code that can do this for me as i have a mutliple forms with thousands of records and it may make it easier

 

[AccessBlaster]

Generally speaking we search tables not forms. Are you saying you want to search from a navigation form and return the results on another form?

 

[riddicule123]

no itslike on the navigation pane at the bottom of each form (e.g next record, new record, previous record) there is a search box, so you can search and bring up the record in the form format. all i want to do is make a form where i can search for a detail and it opens the form on that record that you are searching for the forms are linked to tables but the users dont have access to the tables. all the search box will be for is to amend the record on the form