By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,251 Members | 2,656 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,251 IT Pros & Developers. It's quick & easy.

Subform updating

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

Nov 13 '05 #2

P: n/a
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.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.