Subform updating

[Jason]

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.

[Roel Schoonveld]

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

Roel Schoonveld
ro**@schoonveld.com


ja*******@hotmail.com (Jason) wrote in message news:<34**************************@posting.google. com>...

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.

[Jason]

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.

ro**@schoonveld.com (Roel Schoonveld) wrote in message news:<c6**************************@posting.google. com>...

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

Roel Schoonveld
ro**@schoonveld.com


ja*******@hotmail.com (Jason) wrote in message news:<34**************************@posting.google. com>...

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.