Search function help

[Neekos]

Hey guys,

I have a form that is used solely as a search page. It allows the user to enter either a GroupName or GroupNumber in 2 different text boxes with a button under each one. the OnClick property of the buttons is coded to match either the GroupName or GroupNumber and open a new form with the appropriate data. The search function itself works fine, but my problem is that whenever someone searches for a name or number, it is storing those values in the table. Is it possible to not store these values? Is my design all wrong?

[JKing]

Could you post the code for the Onclick events? This would help us in narrowing down the problem. Thanks.

[Neekos]

Private Sub Command47_Click()
On Error GoTo Err_Command47_Click
 
    Dim stDocName As String
    Dim stLinkCriteria As String
 
    stDocName = "frmMainGroup"
    DoCmd.RunCommand acCmdWindowHide
    stLinkCriteria = "[GroupNumber]=" & "'" & Me![GroupNumber] & "'"
    DoCmd.OpenForm stDocName, , , stLinkCriteria
 
Exit_Command47_Click:
    Exit Sub
 
Err_Command47_Click:
    MsgBox Err.Description
    Resume Exit_Command47_Click
 
End Sub
 

Private Sub Command48_Click()
On Error GoTo Err_Command48_Click
 
    Dim stDocName As String
    Dim stLinkCriteria As String
 
    stDocName = "frmMainGroup"
    DoCmd.RunCommand acCmdWindowHide
    stLinkCriteria = "[GroupName]=" & "'" & Me![GroupName] & "'"
    DoCmd.OpenForm stDocName, , , stLinkCriteria
 
Exit_Command48_Click:
    Exit Sub
 
Err_Command48_Click:
    MsgBox Err.Description
    Resume Exit_Command48_Click
 
End Sub
 

[Neekos]

the problem isnt really with the search function itself, i think its more do with how i have the form set up. the search form has the same RecordSource as the form that i'm opening, which is where its storing these values.

[JKing]

The search form shouldn't be bound and neither should the combo boxes on the search form.

What you want to do is have two unbound combo boxes that through a query look up the values you want rather than having them as bound controls.

[Neekos]

is it possible to do this without using a combo box? Or have the combo box be data entry only? I dont want the user to have the Drop down capabitlites and be able to see all the different names in the list.

[JKing]

You can do the same thing with textboxes. The way you have your code setup I believe if you just remove the record source from the search form and the control sources of the textboxes, it should work fine.

[Neekos]

that worked great! such an easy fix!

Now im having the problem of whenever the user opens the search page, the last thing that was searched for is still in the text box. Its unbound so i'm not sure why this is sticking! Any thoughts?

[JKing]

If they aren't bound this shouldn't be happening. Are you infact closing the search form or just hiding it? Are you setting the default value of the textboxes?

[Neekos]

DoCmd.RunCommand acCmdWindowHide

this is my code....so i am in fact just hiding it. Is that the problem? If so, how can i auto close the window?

[JKing]

You could use Docmd.close to close the search form.

Or if you prefer you could also just clear the textboxes when the user clicks one of the buttons.