Combo boxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bobk - 18 Nov 2005 16:11 GMT

I have a form that has to be filled out. One of the fields in the form
relates to shipping and specifies who the freight company would be for a
specific order. There will be a limited number of freight companies, but the
llist may change and new freight companies may be added. Can I use a combo
box so that as I enter new freight companies, not on the list, into the combo
box, they automatically get added to the list and are available the next time
data is entered? I guess this would be a self-updating list where if the user
couldn't find the company he wanted he could just add it into the combo box
and it would be available the next time he entered data.
Can this be done?

Reply to this Message

SusanV - 18 Nov 2005 16:31 GMT

http://support.microsoft.com/?kbid=209836

Signature

hth,
SusanV

>I have a form that has to be filled out. One of the fields in the form
> relates to shipping and specifies who the freight company would be for a
[quoted text clipped - 11 lines]
> and it would be available the next time he entered data.
> Can this be done?

Reply to this Message

Bobk - 19 Nov 2005 21:11 GMT

Thank you for the help, but I am a beginner at this. I am working with Access
2003. The code in the example says Access 2000. Will it work in 2003? There
is already a Macro1 existing in my database. Can I just add this code to it
or do I need a new Macro2?

> http://support.microsoft.com/?kbid=209836
> >I have a form that has to be filled out. One of the fields in the form
[quoted text clipped - 12 lines]
> > and it would be available the next time he entered data.
> > Can this be done?

Reply to this Message

Douglas J. Steele - 19 Nov 2005 21:36 GMT

Yup, should work in all versions of Access.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Thank you for the help, but I am a beginner at this. I am working with
> Access
[quoted text clipped - 25 lines]
>> > and it would be available the next time he entered data.
>> > Can this be done?

Reply to this Message

John Vinson - 19 Nov 2005 21:40 GMT

>Thank you for the help, but I am a beginner at this. I am working with Access
>2003. The code in the example says Access 2000. Will it work in 2003?

Yes. There are very few differences between the two versions.

>There
>is already a Macro1 existing in my database. Can I just add this code to it
>or do I need a new Macro2?

Add the code.

John W. Vinson[MVP]

Reply to this Message

Bobk - 20 Nov 2005 04:46 GMT

I got the code to work. It does what I want it to do. The only thing that is
happening that I don't understand is I get a message "Microsoft can't find
the macro". Apparently I have not saved the macro correctly. Everthing works
ok but the message tells me something is not exactly correct. What have I
done wrong?

> >Thank you for the help, but I am a beginner at this. I am working with Access
> >2003. The code in the example says Access 2000. Will it work in 2003?
[quoted text clipped - 8 lines]
>
> John W. Vinson[MVP]

Reply to this Message

John Vinson - 20 Nov 2005 18:51 GMT

>I got the code to work. It does what I want it to do. The only thing that is
>happening that I don't understand is I get a message "Microsoft can't find
>the macro". Apparently I have not saved the macro correctly. Everthing works
>ok but the message tells me something is not exactly correct. What have I
>done wrong?

You'll get that message if you have a name in the Event property of a
control which does not correspond to any existing macro.

My assumption was that you would use the same macro you already had,
and add some steps to it.

Without knowing just what you've done I'm not sure where the error
might be - but that's what the error message means; you have something
in the Event Procedure of a form or control which doesn't exist.

John W. Vinson[MVP]

Reply to this Message

Bobk - 25 Nov 2005 00:31 GMT

I fixed the problem by deleting the new code I had entered, then re-entered
everything. It now looks ok - no errors. I searched for the error, but
couldn't see it so re-entering everthing turned out to be the most expedient
solution. Thanks for the help.

> >I got the code to work. It does what I want it to do. The only thing that is
> >happening that I don't understand is I get a message "Microsoft can't find
[quoted text clipped - 13 lines]
>
> John W. Vinson[MVP]

Reply to this Message