Combo boxes

[Guest]

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?

 

[SusanV]

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

 

[Guest]

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?

 

[Douglas J. Steele]

Yup, should work in all versions of Access.

 

[John Vinson]

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]

 

[Guest]

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?

 

[John Vinson]

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]

 

[Guest]

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.