David & Joanne Gould
dajomigo at tpg.com.au
Thu Apr 24 02:13:52 CDT 2003
Thanks David At 20:27 22/04/2003 +1000, you wrote: >On 22 Apr 2003 at 18:33, David & Joanne Gould wrote: > > > I am trying to add a new record into a table when the user types an > > entry into a combo box that triggers the NotInList event. My problem > > is trying to use the text that was typed in. How do I find it > > prgramatically? > > > > The table only has two fields: Autonumber (PK) and a descriptive text > > field. > > > >Look at the NotInList Event: > >Private Sub Combo0_NotInList(NewData As String, Response As Integer) > >NewData contains the newly entered string. >Response is a flag which defines how the event is handled after your >code has been executed in the Sub. > >Just insert NewData into the table and set Response to >acDataErrAdded > > > > > > > > >-- >Lexacorp Ltd >http://www.lexacorp.com.pg >Information Technology Consultancy, Software Development,System >Support. > > > >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com