Setting default column to search in MS Access 2003 with "General Search" enabled?
Posted on 2011-03-13
My client wants me to customize the search function in the MS Access 2003
database I set up for him to default to a specific column (the "Look In" field) AND have
a General search option.
First he wanted me to set it to "Any part of Field". That was no problem, just go
to the menu, options --> Edit/Find tab, and set the value to "General search". Ok, so
far, so good....
Problem is , the Search window defaults to the entire table in the "Look In" field, so he has to click
on that drop-down and select the column (which would only be the second choice
if the cursor is focused in the field he wants to search in). But he does this hundreds of times
a day, so...
He wants to have both the General Search (any part of field) and "Look In" default to one column
in the table. Is this possible? Do I have to to edit the Search's event procedure VB (If so, I'm clueless)
Can anyone help me out?
PS: the VB for the Search is as follows, if I need to edit something in there to make this happen,
Private Sub Find_the_part_Click()
On Error GoTo Err_Find_the_part_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
THANK YOU to anyone who can help!