Modify Search Button by using ComboBox

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
 
N

NFL

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mailto command button in Access. 4
ComboBox is populated but not visible. 1
Modifying Command Button 2
Error 2237 8
Comand Button 2
vba coding 4
"Delete Record" command button woes 4
Help with Macro? 3

Top