Combo box needs to be refreshed

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Norman - 15 May 2007 02:05 GMT

The combo box I created to look up data specific to another field in the form
works fine...except....when I move from one record to the next record on the
continuos form, the drop down box continues to return data specific to the
previous records data.

I solved the problem by putting a "refresh" command button on the form. How
can I have it refresh automatically upon exiting that form?

Speak slowly - I'm learning.

Reply to this Message

scubadiver - 15 May 2007 08:22 GMT

How about a requery command on the "on exit" or "unload" event.

me.[your combo].requery

that might work.

Signature

http://www.patriotsquestion911.com
http://www.911truth.org
http://www.wtc7.net
http://www.st911.org
http://www.journalof911studies.com
http://www.pilotsfor911truth.org
http://ae911truth.org

> The combo box I created to look up data specific to another field in the form
> works fine...except....when I move from one record to the next record on the
[quoted text clipped - 5 lines]
>
> Speak slowly - I'm learning.

Reply to this Message

Norman - 15 May 2007 12:16 GMT

When I added the requery, it does just that - it resets the information in
the combobox as if I never made a selection. It defaults to the first value
in the field. I can't s;ect any value because as soon as I exit it requeries.

> How about a requery command on the "on exit" or "unload" event.
>
[quoted text clipped - 11 lines]
> >
> > Speak slowly - I'm learning.

Reply to this Message