Update Combo Box

[Guest]

Have a Combo Box, "Client Name", that list's current clients. It AutoExpands
& Autocorrects, But, I need it to update any new client that is not in the
table... I've done this beofre, but, I cannot get it to work.....Is it an
"After Update" event procedure ??? I just cannot remember ????

Thanks For Any Help !!!!!

Aaron

 

[Roger Carlson]

Not sure exactly what you mean. If you want to add a new client via the
combo box, on my website (www.rogersaccesslibrary.com), is a small Access
database sample called "NotInList.mdb" which illustrates several ways to do
this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

That should be what I needed,
Thanks for your help...

Aaron

 

[Guest]

That site was VERy HELPFUL....
I tried to Duplicate option #2 of "Notinlist2K", I have a drop down box of
clients, linked to a table that has Just Client & Company info...
When I enter a new client it prompts "Do You want to Add this Value to the
List ?"
I click "Yes", But, I then get an error, Syntax error in INSERT INTO
statment. I can select "debug" and it takes me into the Visual Basic window,
with this statement highlighted in Yellow, "CurrentDb.Execute strsql,
dbFailOnError" ????

Any idea what I'm doing wrong ???

 

[Roger Carlson]

With Option 2, you are only adding one bit of information. I both Client
and Company fields are required, the SQL statement will fail (which is what
the error indicates). You might want to use Option 5 to be able to enter
the additional information.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L