[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