dbTalk Databases Forums  

Re: Combo box problem

comp.database.ms-access comp.database.ms-access


Discuss Re: Combo box problem in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Johnny Meredith
 
Posts: n/a

Default Re: Combo box problem - 04-02-2004 , 12:03 AM






Maybe you can use the OpenArgs optional parameter when you open the small
form to add the item not in the combo box list. Something like this:

NotInList Event:
Private Sub Combo0_NotInList(NewData As String, Response As Integer)
DoCmd.OpenForm "Form2", acNormal, , , acFormAdd, , Me.Combo0.Value
End Sub

Second Form Load Event:
Private Sub Form_Load()
Me.<<Your control here>>.Value = OpenArgs
End Sub

If you are getting the NotInList event to fire properly, this should work.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.