Commond Button

[kavehrad]

Hi everybody!
I want to have a command button to search in a specified field ( like: Name ) in my form. what is the macro code to this button?

Thanks

 

[Gasman]

No need for a button.

Look at https://www.access-programmers.co.u...t-filter-combobox-itself.311342/#post-1691895

 

[Rene vK]

Maybe a bit improper but, "Did you try to find or create something like a search?" People here try to help, not do your work. You will not learn anything if you don't try to invent stuff yourself. Google or Bing is your biggest friend and off course forums like this one.

 

[Rene vK]

Fastest way is to use a combobox with your field as source.
A situation that I use quit often is: a subform showing a table, typing in a textbox rolls-up my table with the result. It works with a sql query.

 

[Deleted member 147267]

Maybe a bit improper but

You're just saying what some of us are thinking, but not necessarily about this thread. The subject comes up from time to time in various places.

 

[arnelgp]

Docmd.RunCommand acCmdFind

 

[Rene vK]

Found on Microsoft: Combobox; search as you type.

 

[kavehrad]

Docmd.RunCommand acCmdFind

Thank you
default is the current document and the whole field
can i put it on specific field and any part of the field?

 

[arnelgp]

place the cursor on the field you want to search, then press your search button.
you must experiment on the combo choices which best fit your need.