Results 1 to 2 of 2
  1. #1
    sk88 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    183

    problems with search as you type forms

    so I have a search-as-you-typed form to search the customer first name and last name. Beside each name, there is an EDIT button where the user can click to open that particular case.
    The customer could have more than one case.

    The EDIT form consist of a main form (where it contains customer information) and a sub form which consist of the type of case and comment box.
    Both the main form and sub form has its own table linked to it.

    the problem right now is when the customer has more than one case, the EDIT form pulls up the first case of the customer even though it shows 3 in the search as you typed form.
    I would like to have EDIT be opened to that particular case.



    I do have this code under EDIT button:
    Code:
    Private Sub Command5_Click()
    #If Not CC_Debug Then
    On Error GoTo ErrProc
    #End If
        
        DoCmd.OpenForm "EditfrmAddNewMain", , , "AuditID=" & Me.txtMetricsID
     DoCmd.Close acForm, "fdlgSearch", acSaveYes
    ExitProc:
        Exit Sub
    ErrProc:
        ErrMsg Err, Err.Description, Err.Source
        Resume ExitProc
    
    
    End Sub
    and
    Code:
    Private Function SelectCus(ByVal lngStudyID As String)
    DoCmd.OpenForm "EditfrmAddNewMain", , , "AuditID = " & Me.txtMetricsID
     
    
    End Function

    The code used to work. However, I think I did something and it is not working right and I can't figure it out.

    PLEASE HELP!

  2. #2
    sk88 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    183
    is it because I now have it saved in Access 2003?
    Before it was in Access 2007?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Search as you type
    By CaptainKen in forum Programming
    Replies: 19
    Last Post: 04-25-2012, 12:55 PM
  2. Few Problems : Search Button Form
    By spideynok in forum Forms
    Replies: 10
    Last Post: 03-29-2012, 01:13 AM
  3. SEARCH problems with Access and MySql
    By azirion in forum Access
    Replies: 2
    Last Post: 08-27-2011, 05:02 PM
  4. search as you type in combo box
    By pratim09 in forum Forms
    Replies: 3
    Last Post: 08-05-2011, 07:46 AM
  5. Replies: 3
    Last Post: 06-04-2011, 12:23 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums