Requery?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TKM - 30 May 2007 21:43 GMT

I have a main form A that has a Combo box for part selections. I also have a
button next to the txt field where it opens a little form to add additional
parts as needed. However I cant get the part to show up in Form A (main Form)
after I have added it to form B. I have tried every type of requerry on each
form and control but nothing works. Please help.

Reply to this Message

Ripper - 30 May 2007 22:07 GMT

I have had similar issues with combo boxes. My fix was in the OnClose event
of the Add Part Form, I close and re-open the main form. That forces the
combo box to requery.

Signature

Rip

> I have a main form A that has a Combo box for part selections. I also have a
> button next to the txt field where it opens a little form to add additional
> parts as needed. However I cant get the part to show up in Form A (main Form)
> after I have added it to form B. I have tried every type of requerry on each
> form and control but nothing works. Please help.

Reply to this Message

TKM - 30 May 2007 23:36 GMT

Yes I have done that in the past but you would think with Access 2007 they
would have fixed it. Funny if I place a button next to the cbo it works fine.
But no way will it work on the cbo dbl clck property.
Go figure?

> I have had similar issues with combo boxes. My fix was in the OnClose event
> of the Add Part Form, I close and re-open the main form. That forces the
[quoted text clipped - 5 lines]
> > after I have added it to form B. I have tried every type of requerry on each
> > form and control but nothing works. Please help.

Reply to this Message

Marshall Barton - 31 May 2007 02:08 GMT

>I have a main form A that has a Combo box for part selections. I also have a
>button next to the txt field where it opens a little form to add additional
>parts as needed. However I cant get the part to show up in Form A (main Form)
>after I have added it to form B. I have tried every type of requerry on each
>form and control but nothing works.

There must be something funny in your arrangement ;-)

After the "little" form closes, the code in the button's
click event procedure should resume (you are opening the
little form in Dialog mode, right?) and then you can
requery.

    DoCmd.OpenForm "littleform", WindowMode:=acDialog

    Me.combobox.Requery
or
    Me.Requery

Signature

Marsh
MVP [MS Access]

Reply to this Message