Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Michelle86

    Using VB code to run search from comboboxes & place results in form

    No luck I'm afraid! Still can't get it to work. Michelle
  2. Michelle86

    Using VB code to run search from comboboxes & place results in form

    unfortunately it still doesn't work! Michelle
  3. Michelle86

    Using VB code to run search from comboboxes & place results in form

    It brought up a syntax error because there was no space between the strFilter and the & e.g. strFilter = strFilter&. So when you changed it, obviously brought up the same error. Thanks for your effort Michelle
  4. Michelle86

    Using VB code to run search from comboboxes & place results in form

    If i chang it back to strFilter is brings up a form with no details in it. Here's my code: Private Sub btnSearchForProspect_Click() Dim strSQL As String Dim strFilter As String 'Code to automatically open form If SysCmd(acSysCmdGetObjectState, acForm, "frmEditProspect") <>...
  5. Michelle86

    Using VB code to run search from comboboxes &amp; place results in form

    Thanks scottsanpedro for your quick reply! When I select a criteria and run it, a run time error occurs '2448'. Saying "you can't assign a value to this object". When I go to debug it highlights the following code: .Filter = strSQL Can you suggest any reasons? Thanks
  6. Michelle86

    Using VB code to run search from comboboxes &amp; place results in form

    Hi, I'm trying to have a form that allows the users to select search criteria from 3 drop down boxes. They can choose to select criteria from 1, 2 or all of the boxes. However when I choose the criteria it only seems to work for the Division criteria on its own and none of the others!! Please...

Part and Inventory Search

Back
Top