Subform updating

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Jason
    #1

    Subform updating

    I am creating a form that has a subform. The main form is unbound
    with a combo box, list box and a textbox. I need to get the subform
    (a form that is bound to a query) to automatically update whenever an
    item in the listbox is clicked, or whenever the textbox gets updated.

    Thanks for your help.
    Tags: None
    • Roel Schoonveld
      #2
      Re: Subform updating

      You could use 'Sendkeys "{F9}" ' as a AfterUpdate VBAcode in your textbox.

      Roel Schoonveld
      roel@schoonveld .com






      jason_cyr@hotma il.com (Jason) wrote in message news:<3416e54f. 0408061242.6f16 3bbe@posting.go ogle.com>...[color=blue]
      > I am creating a form that has a subform. The main form is unbound
      > with a combo box, list box and a textbox. I need to get the subform
      > (a form that is bound to a query) to automatically update whenever an
      > item in the listbox is clicked, or whenever the textbox gets updated.
      >
      > Thanks for your help.[/color]

        Comment

        • Jason
          #3
          Re: Subform updating

          Thanks for your help, that has solved the problem. I do have another
          problem with the list box. Everytime I click a value in the list box,
          it goes to the top of the list for that letter. (Eg. If I have 10 "N"
          values, clicking on item 10 will force the list box to go to the "N"
          at the top of the list. I need the box to hold the value that was
          clicked.

          Is there something that I can do to fix this? Thanks.





          roel@schoonveld .com (Roel Schoonveld) wrote in message news:<c6ede50c. 0408070729.53b9 0717@posting.go ogle.com>...[color=blue]
          > You could use 'Sendkeys "{F9}" ' as a AfterUpdate VBAcode in your textbox.
          >
          > Roel Schoonveld
          > roel@schoonveld .com
          >
          >
          >
          >
          >
          >
          > jason_cyr@hotma il.com (Jason) wrote in message news:<3416e54f. 0408061242.6f16 3bbe@posting.go ogle.com>...[color=green]
          > > I am creating a form that has a subform. The main form is unbound
          > > with a combo box, list box and a textbox. I need to get the subform
          > > (a form that is bound to a query) to automatically update whenever an
          > > item in the listbox is clicked, or whenever the textbox gets updated.
          > >
          > > Thanks for your help.[/color][/color]

            Comment

            Previous template Next
            Working...