[AccessD] NotInList (AXP)

Terri

"Not In List" is it's own event.

==================================
Private Sub lngYourFieldID_NotInList(NewData As String, Response As Integer)
...
End Sub
==================================

Regards,
Bob Gajewski


On Wednesday, April 30, 2003 14:41 PM, Terri Jarus [SMTP:jarus at amerinet-gpo.com] wrote:
> 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
> 
> 
>