Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2016
    Posts
    8

    Unanswered: Requery a listbox automatically when moving the records

    Hi,

    I have a listbox having the rowsource with where clause (criteria) based on a textbox. In order to display the data in listbox, I'm using the Click Event in the textbox to requery the listbox.
    I'm wondering if I could use the methods below to populate the data automatically/requery in the listbox when I'm moving to every records
    1) link the listbox to the textbox (like linking the subform to textbox -- master field and child field)
    2) requery the listbox automatically

    I know it could be accomplished with creating a subform and link to the textbox but it could cause too many subform in the main form

    Could anyone help me on this. Thanks in advance.

    Regards,
    tserhung

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    629
    Provided Answers: 34
    you only need 1 subform in the form.
    click the item in the listbox,
    set the query for the subform

    subform.rowsource = lstBox

  3. #3
    Join Date
    Mar 2016
    Posts
    8
    Hi ranman256,

    Thank you for your advice. I've created a subform to solve the problem.

    Appreciate your help

    Regards,
    tserhung

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •