Results 1 to 5 of 5
  1. #1
    mathanraj76 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2013
    Posts
    39

    search data by click the textbox and pop up complete data in the main form

    Hi ..
    I have a search form and main input data form..
    When I click the search form text box, the complete for the particular customer details must show on the main input form

    For an example
    In search form, I have company name textbox,customer name textbox address1 and so on..
    when i type and search the data on the search form it will show the records on the search form then
    When i click the company name textbox or customer name textbox or anyfields textbox in search form the particular complete data must show on main input form..



    Thanks
    Mathanraj
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    You could use the filter method already given in your other threads - use code to build filter string and set Filter and FilterOn properties of form.

    Use the same filter criteria to open a data entry/edit form filtered to the desired record.

    Post attempted code for analysis if you encounter issue.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    mathanraj76 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2013
    Posts
    39
    this search is like i choose the fields name and type in the name into textbox search and click the command button will show all the records related which i type in.
    It something like "find as you type"
    How you want to put the codes which you give me.

    so i use
    sWHERE = "[myfieldname] = '" & myfieldname & "'" then from here i edit the record into the forms

    Do you any other better ways to do it..
    If yes pls guide me..
    Thanks
    Mathanraj

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    And is that working? Are you filtering the open form or do you want another form to open filtered to that record?

    In either case, use unique ID from the selected record.

    To open another form filtered to single record:

    DoCmd.OpenForm "formname", , , "unique ID field name" = & Me.[unique ID textbox name]
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    mathanraj76 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2013
    Posts
    39
    for sure i will try .. and let you know
    your codes always work perfect for me..

    Thanks
    Mathanraj

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

Similar Threads

  1. Replies: 25
    Last Post: 08-01-2012, 05:22 PM
  2. Replies: 12
    Last Post: 03-22-2012, 02:48 AM
  3. Replies: 4
    Last Post: 12-22-2011, 03:04 AM
  4. Replies: 4
    Last Post: 01-05-2011, 07:56 AM
  5. Auto Complete Data
    By manicamaniac in forum Access
    Replies: 5
    Last Post: 09-14-2010, 03:38 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