jwcolby
jwcolby at colbyconsulting.com
Mon Mar 30 10:39:49 CDT 2009
NotInList is simply an event that fires. You can do anything you want with the event. I tend to do one of two things depending on the complexity of the data behind the list. 0) Inform the user that the data is not in the list and ask them if they want to perform the action that you are about to perform... 1) Open a pop-up form if the data is complex. You would open the form in data entry mode to add a new record. You use this for things like a person table where you have to add a ton of information about the object. or 2) Run an append query to append a single field to a simple one field list table. The data appended is the value in the combo box that is not in the list. You use this for simple tables such as color (or lack thereof depending on the other thread), model of car, etc. In either case you need to then requery the combo box when the action above has finished. This implies opening the form modal (if you use the form) so that code execution stops and waits for the form to close. If you need more help than this, please just say so. HTH John W. Colby www.ColbyConsulting.com Martin, Donna M wrote: > Hi guys! > > I really am stumped on this one, and could use a little help... > > I am trying to combine two tables using a UNION query that come from different databases. This appears to be no problem. I will be using this in a combo-box. My problem comes when Not in List happens, as I will need to add rows to only one of these tables. I'm having difficulty getting to the right database table, adding it to the combo-box, and getting back to the form. This is probably way simple, but I'm having a major brain burp... > > So sorry to bother you guys, but am really freaking out on this, and need to get this launched soon. > > TIA, > Donna > > PSI just rejoined the AccessD listserv two weeks ago, which I think is a great resource! > > > > ________________________________ > This e-mail message (including any attachments) is for the sole use of > the intended recipient(s) and may contain confidential and privileged > information. If the reader of this message is not the intended > recipient, you are hereby notified that any dissemination, distribution > or copying of this message (including any attachments) is strictly > prohibited. > > If you have received this message in error, please contact > the sender by reply e-mail message and destroy all copies of the > original message (including attachments).