Update Table From Combo Box.

  • Thread starter Thread starter Dragon
  • Start date Start date
D

Dragon

Hi,

I have a form based on a single table. On the form I am using a couple of
combo boxes. The list sources for these combo boxes are 2 other tables.
Until now, I have it set to users are limited to the selections in the
lists. If they wanted to add something else, they would have to add it in
those tables first. Now I want it so they can enter anything they want in
the combo box and if it is not in the list table it adds it to that table as
well. Any idea how would I go about that?

Thank you.
 
Hi,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

The following Knowledge Base article should get you going in the right
direction:

ACC2000: Use NotInList Event to Add a Record to Combo Box

http://support.microsoft.com/default.aspx?scid=kb;en-us;19752

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 
Thank you Dennis but unfortunately I was unable to locate the page and/or
article you suggested. If you have access to it, do you mind pasting it
here? I've been getting the following error for last two days accessing the
link.

The article you are looking for is currently not available

Thank you.
 
Back
Top