unbound combo box to update list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

awrex - 23 May 2007 23:10 GMT

I have a combo box that is unbound that I'd like to be able to update if
there is new data.

I was looking at Allen Browne's example - http://allenbrowne.com/ser-27.html

however I have a unbound combo box, would anyone know how I could make this
happen?

THANKS!!!

Reply to this Message

Ofer Cohen - 24 May 2007 00:24 GMT

Have you tried this code? what happen?

Look at this link, there is another example

http://www.databasedev.co.uk/not_in_list.html

Signature

Good Luck
BS"D

> I have a combo box that is unbound that I'd like to be able to update if
> there is new data.
[quoted text clipped - 5 lines]
>
> THANKS!!!

Reply to this Message

awrex - 24 May 2007 16:11 GMT

Thank you!!! Works like a charm!!!!

Using AB's code gave me a invalid use of ME! error, could be that did not
have the RowSourceType set to the table.

> Have you tried this code? what happen?
>
[quoted text clipped - 11 lines]
> >
> > THANKS!!!

Reply to this Message

Ofer Cohen - 24 May 2007 16:30 GMT

In some case the Me!FieldNAme gives an error, next time try Me.FieldName

Signature

Good Luck
BS"D

> Thank you!!! Works like a charm!!!!
>
[quoted text clipped - 16 lines]
> > >
> > > THANKS!!!

Reply to this Message

awrex - 24 May 2007 23:49 GMT

Thank you... I did try that, though after a few attempts I went looking for
an alternate answer which I found. THANKS AGAIN!!!!

> In some case the Me!FieldNAme gives an error, next time try Me.FieldName
>
[quoted text clipped - 18 lines]
> > > >
> > > > THANKS!!!

Reply to this Message