MS Access Record Search and Form Population
Posted on 2007-08-02
I've created a form for users to Search/Edit records they create. I want to allow them to search for records using the Record ID, Sales Engineer, or Customer Name. I have the first option (ID SEarch) working using the first script below.
The second script is one that I'm attempting to use to search for records using a text field, allowing the user to search by "Sales Engineer". I have the form data source set to a Query 1 that list the Record ID, Sales Engineer and Customer. I can't seem to get this search to work like the ID Serch. Please let me know what I'm missing.
Private Sub Command5_Click()
On Error GoTo Err_Command5_Click
DoCmd.OpenForm "TSE Input Form", , , "[ID]=" & Text3.Text
Private Sub FindRecord_Click()
On Error GoTo Err_FindRecord_Click
DoCmd.OpenForm "TSE Input Form", , , "[Sales Engineer]="" & text0.Text & """