David McAFee (Home)
dmcafee at pacbell.net
Wed Apr 30 14:00:23 CDT 2003
It goes in the NotInList event of the combobox. Check out Roger's examples: http://rogersaccesslibrary.com/TableOfContents.asp#N HTH David McAfee -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Terri Jarus Sent: Wednesday, April 30, 2003 11:41 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] NotInList (AXP) I tried that - but am not sure where exactly to put it. I tried putting it in the GotFocus event of frmStock, but it doesn't work. Where should the requery go? >>> CWortz at tea.state.tx.us 04/30/03 12:47PM >>> Terri, When you return to frmStock you want to requery the record source for the combo box so it will show the new entry. Charles Wortz Software Development Division Texas Education Agency 1701 N. Congress Ave Austin, TX 78701-1494 512-463-9493 CWortz at tea.state.tx.us -----Original Message----- From: Terri Jarus [mailto:jarus at amerinet-gpo.com] Sent: Wednesday 2003 Apr 30 12:41 To: accessd at databaseadvisors.com Subject: [AccessD] NotInList (AXP) This is probably very simple, but I'm not understanding how to do this. I have a form (frmStock) with a combo box - cboFacNum. If the number the user wishes to use is not in the list, I need to open another form (frmAdd) to add that number and additional information - then return to the original form and continue on. How do you make this work so that when you come back to frmStock to continue on - the item you just added is in the combo box listing? Thanks for any help. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com