Find and search button on a form 1

[thowe]

Hello- here is what I want to do...(I'm not a programmer, and am using Access 97)

I want to make a button that will open a form, type in my criteria, click find button and have the db return all matching records to specified criteria. I would like to do this with macros using the macro features in Access, since I don't write code.

 

[SyedAqif]

Hi

Here is the simple way to find a record. On ur forms (say Orders form)You have also got a text box called as "TxtCriteria" for inputing criteria and a command button called "TxtFind". Suppose u have opened an orders form and u want that Access should find the record of whatever OrderID u'll enter in txtcriteria.

Make a macor n give follwing actions and fill in thier arguments.

1. GoToControl
Control Name: OrderID

2. FindRecord
Find What: =[txtcriteria]
Match: Whole Field
Match Case: No
Search: All (Can also try Down or Up Argument)
Leave other arguments as default.

Set the macro behind click even of that buton and when u'll press TxtFind button it will find the record corresponding to TxtCriteria.

Hope this will help u.

Cheers!
Aqif

 

[thowe]

I'm sorry, it is not working. I open my form called "videos" put a button on this form that is attached to a macro that has the following actions:
gotocontrol
control Name: (what to put here, don't really understand what 'control name' is suppossed to do

findRecord

 

[SyedAqif]

1. Create a button on vides form and name it as "CmdFind"
2. Create a text box on Video form and name it as "Txtcriteria"

Make a macor n give follwing actions and fill in thier arguments.

1. GoToControl
Control Name: VideoID (VideoId is the name of the textbox on video form containing something like Video ID or Order ID)

2. FindRecord
Find What: =[txtcriteria]
Match: Whole Field
Match Case: No
Search: All (Can also try Down or Up Argument)
Leave other arguments as default.

Just fill in the arguments and I m sure u'll work soemthing out. Hope it will solve ur problem

Cheers!
Aqif