|  | Update List Box with Form Data |  | |
| | | magmike |  |
| Posted: Wed Sep 03, 2008 8:31 pm Post subject: Update List Box with Form Data |  |
I have a list box on a form that shows all the letters that have been sent to a certainly company that the form is currently displaying. When a new letter is created on the form, i'd like the list box to automatically update with the fields as they are entered.
I have set each field to run the Macro "Refresh" OnExit, but oddly enough, that only seems to work after the fifth field.
What is the best way to get the List box to update as each field is updated?
Thanks in advance! magmike |
| |
| | | KARL DEWEY |  |
| Posted: Wed Sep 03, 2008 8:31 pm Post subject: RE: Update List Box with Form Data |  |
Set each field to run the Macro "Refresh" AfterUpdate. -- KARL DEWEY Build a little - Test a little
"magmike" wrote:
| Quote: | I have a list box on a form that shows all the letters that have been sent to a certainly company that the form is currently displaying. When a new letter is created on the form, i'd like the list box to automatically update with the fields as they are entered.
I have set each field to run the Macro "Refresh" OnExit, but oddly enough, that only seems to work after the fifth field.
What is the best way to get the List box to update as each field is updated?
Thanks in advance! magmike
|
|
| |
| | | magmike |  |
| Posted: Wed Sep 03, 2008 9:06 pm Post subject: Re: Update List Box with Form Data |  |
On Sep 3, 3:43 pm, KARL DEWEY <KARLDE...@discussions.microsoft.com> wrote:
| Quote: | Set each field to run the Macro "Refresh" AfterUpdate. -- KARL DEWEY Build a little - Test a little
"magmike" wrote: I have a list box on a form that shows all the letters that have been sent to a certainly company that the form is currently displaying. When a new letter is created on the form, i'd like the list box to automatically update with the fields as they are entered.
I have set each field to run the Macro "Refresh" OnExit, but oddly enough, that only seems to work after the fifth field.
What is the best way to get the List box to update as each field is updated?
Thanks in advance! magmike- Hide quoted text -
- Show quoted text -
|
That doesn't seem to be working either, until the fifth field is passed through. I just don't get it. |
| |
|
|