search in the form

[eran185]

hey

i have a main form ( there is link to my forms and my reports).

in one of my forms , i have a id field.

i want to do a macro or something like these that will do this things :

1-go to the form

2-go to the id field

3-push ctrl+f (search in a specific field - the id field)



how can i do this ?

 

[agehoops]

Hiya.
It doesn't have to be done with a macro, it can be done in VB but if you want to do it in a macro then do this:

Create a new macro
In the action column create the following 3 actions:
OpenForm
GoToControl
SearchForRecord

Change the properties for each one to the values you require
In your main form or switchboard, change the "OnClick" event properties of the button you want it to work on, to the name of the macro you've just created. It should then run the macro when you click the button.

Hope this helps

 

[eran185]

.

but i dont see SearchForRecord ...

 

[agehoops]

Oh right. May be a new feature on office 2007.

Does it have to be the ctrl+F search function? If not you could create a custom function and get it to run that instead?

 

[eran185]

thank's

thank's