Commond Button (1 Viewer)

kavehrad

New member
Local time
Today, 12:00
Joined
Jun 14, 2020
Messages
17
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:)
 

Rene vK

Member
Local time
Today, 12:00
Joined
Mar 3, 2013
Messages
123
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

Member
Local time
Today, 12:00
Joined
Mar 3, 2013
Messages
123
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.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 19:00
Joined
May 7, 2009
Messages
19,169
Docmd.RunCommand acCmdFind
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 19:00
Joined
May 7, 2009
Messages
19,169
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.
 

Users who are viewing this thread

Top Bottom