Results 1 to 4 of 4
  1. #1
    dotfb is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    2

    Search and display in 1 Form without using Split form


    Hello Everyone!

    I just want to ask a solution about search and display in 1 form. Just like when you search data, it will show the whole information of the data comming from datasheet. and it will display into the textbox that chosen to the database.

    I just want to display the datasheet and specified field(which will display in textbox) and can search also.

    Im newbie with this ms access programming..i hope you guys give me some good advice..tnx in advance to all!GB

  2. #2
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    So you want a

    Search field
    unbound field
    datasheet below


    You could filter a subform - datasheet/listbox/continuous form and have the searched result if unique show in a text field above (the unbound one)

    Is this sort of what you want?

  3. #3
    dotfb is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    2
    Quote Originally Posted by Ruegen View Post
    So you want a

    Search field
    unbound field
    datasheet below


    You could filter a subform - datasheet/listbox/continuous form and have the searched result if unique show in a text field above (the unbound one)

    Is this sort of what you want?
    Exactly!this is what i need sir..thanks a lot for this info.. last question sir..is there any video tutorial about this kind of problem..?

  4. #4
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Not that I know of personally.

    It's a mixed bag. You'd need one to learn how to filter a subform or continuous form. Then another on how to pass the value of the first record into the control value of the unbound text box on the parent form.

    this code will filter your subform if used in the text box's after update event
    Code:
    me.yoursubformname.form.filter = "[yourfield] like" & "*" me.yourTextBoxControl & "*"
    me.yoursubformname.form.filteron = true

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

Similar Threads

  1. Get split form behaviours without using a split form
    By SyntaxSocialist in forum Queries
    Replies: 2
    Last Post: 04-12-2013, 11:56 AM
  2. Replies: 5
    Last Post: 01-03-2013, 01:38 PM
  3. Replies: 1
    Last Post: 04-20-2012, 03:16 AM
  4. Replies: 1
    Last Post: 07-21-2011, 01:57 PM
  5. Display Fields in Search Form
    By j2curtis64 in forum Forms
    Replies: 1
    Last Post: 07-18-2011, 01:37 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