Modify Search Button by using ComboBox

  • Thread starter Thread starter NFL
  • Start date Start date
N

NFL

Below is a standard code used to search a record on the form. Is there a
way I can modify the code to search a specific record from a dropdown list
using the combo box text field instead of the standard dialog box that asks
for more input by the user?

Thank you

On Error GoTo Err_Command31_Click


Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Exit_Command31_Click:
Exit Sub

Err_Command31_Click:
MsgBox Err.Description
Resume Exit_Command31_Click
 
I apologize for my confusion. I really wanted to know if there is a way I
can use the combo box to interact with a report, rather than a dialog box
looking for input. I'm not sure if it is possible, unless it can be done
thru a query.
 
Back
Top