Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

I need help

Discussion in 'Information Technology' started by antonov, Nov 9, 2005.

Tags:
  1. antonov

    antonov
    Expand Collapse
    Guest

    here I am again..
    I have this form in which I can input data... I have a cbobox in which some
    data appears. On "on not on list" another form appears in edit mode and I
    can insert some new data... but I cannot save the data.... can somebody
    please tell me why?
     
  2. Loading...

    Similar Threads Forum Date
    Interracial And Interfaith Marriage, Help Needed To Confront/convince My Parents Love & Marriage Aug 16, 2016
    17 yr old Baljit needs your help Get Involved Aug 19, 2015
    Learn Punjabi Need help Language, Arts & Culture May 20, 2014
    United Sikhs From United Sikhs. Phillippines Needs Your Help Sikh Organisations Nov 22, 2013
    Need Help... (Keeping Hair) Questions and Answers Sep 2, 2013

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    What do you mean by "cannot save the data"? Do you get an error? If you open
    the form on its own (i.e.: not from within the NotOnList event), can you
    save data?

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "antonov" <antonov@dds.nl> wrote in message
    news:fU7cf.7726$OR3.6602@tornado.fastwebnet.it...
    > here I am again..
    > I have this form in which I can input data... I have a cbobox in which

    some
    > data appears. On "on not on list" another form appears in edit mode and I
    > can insert some new data... but I cannot save the data.... can somebody
    > please tell me why?
    >
    >
    >
     
  4. antonov

    antonov
    Expand Collapse
    Guest

    yes, if I open the form on its own I can save the data
    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:%23%23ssNPK5FHA.2092@TK2MSFTNGP12.phx.gbl...
    > What do you mean by "cannot save the data"? Do you get an error? If you
    > open
    > the form on its own (i.e.: not from within the NotOnList event), can you
    > save data?
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "antonov" <antonov@dds.nl> wrote in message
    > news:fU7cf.7726$OR3.6602@tornado.fastwebnet.it...
    >> here I am again..
    >> I have this form in which I can input data... I have a cbobox in which

    > some
    >> data appears. On "on not on list" another form appears in edit mode and I
    >> can insert some new data... but I cannot save the data.... can somebody
    >> please tell me why?
    >>
    >>
    >>

    >
    >
     
  5. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    And do you get an error when you open it through the NotOnList event? If so,
    what's the error?

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "antonov" <antonov@dds.nl> wrote in message
    news:5m8cf.7799$OR3.5969@tornado.fastwebnet.it...
    > yes, if I open the form on its own I can save the data
    > "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    > news:%23%23ssNPK5FHA.2092@TK2MSFTNGP12.phx.gbl...
    > > What do you mean by "cannot save the data"? Do you get an error? If you
    > > open
    > > the form on its own (i.e.: not from within the NotOnList event), can you
    > > save data?
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > > "antonov" <antonov@dds.nl> wrote in message
    > > news:fU7cf.7726$OR3.6602@tornado.fastwebnet.it...
    > >> here I am again..
    > >> I have this form in which I can input data... I have a cbobox in which

    > > some
    > >> data appears. On "on not on list" another form appears in edit mode and

    I
    > >> can insert some new data... but I cannot save the data.... can somebody
    > >> please tell me why?
    > >>
    > >>
    > >>

    > >
    > >

    >
    >
     
  6. antonov

    antonov
    Expand Collapse
    Guest

    The error is:
    "The text you entere isn't an item in the list.
    select an item from the list, or enter text that matches one of the listed
    items."
    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:%23PTgcsK5FHA.2624@TK2MSFTNGP14.phx.gbl...
    > And do you get an error when you open it through the NotOnList event? If
    > so,
    > what's the error?
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "antonov" <antonov@dds.nl> wrote in message
    > news:5m8cf.7799$OR3.5969@tornado.fastwebnet.it...
    >> yes, if I open the form on its own I can save the data
    >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    >> news:%23%23ssNPK5FHA.2092@TK2MSFTNGP12.phx.gbl...
    >> > What do you mean by "cannot save the data"? Do you get an error? If you
    >> > open
    >> > the form on its own (i.e.: not from within the NotOnList event), can
    >> > you
    >> > save data?
    >> >
    >> > --
    >> > Doug Steele, Microsoft Access MVP
    >> > http://I.Am/DougSteele
    >> > (no e-mails, please!)
    >> >
    >> >
    >> > "antonov" <antonov@dds.nl> wrote in message
    >> > news:fU7cf.7726$OR3.6602@tornado.fastwebnet.it...
    >> >> here I am again..
    >> >> I have this form in which I can input data... I have a cbobox in which
    >> > some
    >> >> data appears. On "on not on list" another form appears in edit mode
    >> >> and

    > I
    >> >> can insert some new data... but I cannot save the data.... can
    >> >> somebody
    >> >> please tell me why?
    >> >>
    >> >>
    >> >>
    >> >
    >> >

    >>
    >>

    >
    >
     
  7. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Sounds as though you've forgotten to include the line of code

    Response = acDataErrAdded

    in your NotInList event after the data has been added by the form

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "antonov" <antonov@dds.nl> wrote in message
    news:Etgcf.8116$OR3.6101@tornado.fastwebnet.it...
    > The error is:
    > "The text you entere isn't an item in the list.
    > select an item from the list, or enter text that matches one of the listed
    > items."
    > "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    > news:%23PTgcsK5FHA.2624@TK2MSFTNGP14.phx.gbl...
    > > And do you get an error when you open it through the NotOnList event? If
    > > so,
    > > what's the error?
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > > "antonov" <antonov@dds.nl> wrote in message
    > > news:5m8cf.7799$OR3.5969@tornado.fastwebnet.it...
    > >> yes, if I open the form on its own I can save the data
    > >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    > >> news:%23%23ssNPK5FHA.2092@TK2MSFTNGP12.phx.gbl...
    > >> > What do you mean by "cannot save the data"? Do you get an error? If

    you
    > >> > open
    > >> > the form on its own (i.e.: not from within the NotOnList event), can
    > >> > you
    > >> > save data?
    > >> >
    > >> > --
    > >> > Doug Steele, Microsoft Access MVP
    > >> > http://I.Am/DougSteele
    > >> > (no e-mails, please!)
    > >> >
    > >> >
    > >> > "antonov" <antonov@dds.nl> wrote in message
    > >> > news:fU7cf.7726$OR3.6602@tornado.fastwebnet.it...
    > >> >> here I am again..
    > >> >> I have this form in which I can input data... I have a cbobox in

    which
    > >> > some
    > >> >> data appears. On "on not on list" another form appears in edit mode
    > >> >> and

    > > I
    > >> >> can insert some new data... but I cannot save the data.... can
    > >> >> somebody
    > >> >> please tell me why?
    > >> >>
    > >> >>
    > >> >>
    > >> >
    > >> >
    > >>
    > >>

    > >
    > >

    >
    >
     
  8. antonov

    antonov
    Expand Collapse
    Guest

    ehmmm...
    I've created a macro ("add") which opens the form (edit mode) if the name is
    not in the combo...
    I've linked this macro to the cbobox if NotOnList... where do I add the code
    you wrote?
    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:uPKZbDS5FHA.2916@TK2MSFTNGP11.phx.gbl...
    > Sounds as though you've forgotten to include the line of code
    >
    > Response = acDataErrAdded
    >
    > in your NotInList event after the data has been added by the form
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "antonov" <antonov@dds.nl> wrote in message
    > news:Etgcf.8116$OR3.6101@tornado.fastwebnet.it...
    >> The error is:
    >> "The text you entere isn't an item in the list.
    >> select an item from the list, or enter text that matches one of the
    >> listed
    >> items."
    >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    >> news:%23PTgcsK5FHA.2624@TK2MSFTNGP14.phx.gbl...
    >> > And do you get an error when you open it through the NotOnList event?
    >> > If
    >> > so,
    >> > what's the error?
    >> >
    >> > --
    >> > Doug Steele, Microsoft Access MVP
    >> > http://I.Am/DougSteele
    >> > (no e-mails, please!)
    >> >
    >> >
    >> > "antonov" <antonov@dds.nl> wrote in message
    >> > news:5m8cf.7799$OR3.5969@tornado.fastwebnet.it...
    >> >> yes, if I open the form on its own I can save the data
    >> >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
    >> >> message
    >> >> news:%23%23ssNPK5FHA.2092@TK2MSFTNGP12.phx.gbl...
    >> >> > What do you mean by "cannot save the data"? Do you get an error? If

    > you
    >> >> > open
    >> >> > the form on its own (i.e.: not from within the NotOnList event), can
    >> >> > you
    >> >> > save data?
    >> >> >
    >> >> > --
    >> >> > Doug Steele, Microsoft Access MVP
    >> >> > http://I.Am/DougSteele
    >> >> > (no e-mails, please!)
    >> >> >
    >> >> >
    >> >> > "antonov" <antonov@dds.nl> wrote in message
    >> >> > news:fU7cf.7726$OR3.6602@tornado.fastwebnet.it...
    >> >> >> here I am again..
    >> >> >> I have this form in which I can input data... I have a cbobox in

    > which
    >> >> > some
    >> >> >> data appears. On "on not on list" another form appears in edit mode
    >> >> >> and
    >> > I
    >> >> >> can insert some new data... but I cannot save the data.... can
    >> >> >> somebody
    >> >> >> please tell me why?
    >> >> >>
    >> >> >>
    >> >> >>
    >> >> >
    >> >> >
    >> >>
    >> >>
    >> >
    >> >

    >>
    >>

    >
    >
     
  9. antonov

    antonov
    Expand Collapse
    Guest

    ehmmm...
    I've created a macro ("add") which opens the form (edit mode) if the name is
    not in the combo...
    I've linked this macro to the cbobox if NotOnList... where do I add the code
    you wrote?
    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:uPKZbDS5FHA.2916@TK2MSFTNGP11.phx.gbl...
    > Sounds as though you've forgotten to include the line of code
    >
    > Response = acDataErrAdded
    >
    > in your NotInList event after the data has been added by the form
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "antonov" <antonov@dds.nl> wrote in message
    > news:Etgcf.8116$OR3.6101@tornado.fastwebnet.it...
    >> The error is:
    >> "The text you entere isn't an item in the list.
    >> select an item from the list, or enter text that matches one of the
    >> listed
    >> items."
    >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    >> news:%23PTgcsK5FHA.2624@TK2MSFTNGP14.phx.gbl...
    >> > And do you get an error when you open it through the NotOnList event?
    >> > If
    >> > so,
    >> > what's the error?
    >> >
    >> > --
    >> > Doug Steele, Microsoft Access MVP
    >> > http://I.Am/DougSteele
    >> > (no e-mails, please!)
    >> >
    >> >
    >> > "antonov" <antonov@dds.nl> wrote in message
    >> > news:5m8cf.7799$OR3.5969@tornado.fastwebnet.it...
    >> >> yes, if I open the form on its own I can save the data
    >> >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
    >> >> message
    >> >> news:%23%23ssNPK5FHA.2092@TK2MSFTNGP12.phx.gbl...
    >> >> > What do you mean by "cannot save the data"? Do you get an error? If

    > you
    >> >> > open
    >> >> > the form on its own (i.e.: not from within the NotOnList event), can
    >> >> > you
    >> >> > save data?
    >> >> >
    >> >> > --
    >> >> > Doug Steele, Microsoft Access MVP
    >> >> > http://I.Am/DougSteele
    >> >> > (no e-mails, please!)
    >> >> >
    >> >> >
    >> >> > "antonov" <antonov@dds.nl> wrote in message
    >> >> > news:fU7cf.7726$OR3.6602@tornado.fastwebnet.it...
    >> >> >> here I am again..
    >> >> >> I have this form in which I can input data... I have a cbobox in

    > which
    >> >> > some
    >> >> >> data appears. On "on not on list" another form appears in edit mode
    >> >> >> and
    >> > I
    >> >> >> can insert some new data... but I cannot save the data.... can
    >> >> >> somebody
    >> >> >> please tell me why?
    >> >> >>
    >> >> >>
    >> >> >>
    >> >> >
    >> >> >
    >> >>
    >> >>
    >> >
    >> >

    >>
    >>

    >
    >
     
  10. antonov

    antonov
    Expand Collapse
    Guest

    ehmmm...
    I've created a macro ("add") which opens the form (edit mode) if the name is
    not in the combo...
    I've linked this macro to the cbobox if NotOnList... where do I add the code
    you wrote?
    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:uPKZbDS5FHA.2916@TK2MSFTNGP11.phx.gbl...
    > Sounds as though you've forgotten to include the line of code
    >
    > Response = acDataErrAdded
    >
    > in your NotInList event after the data has been added by the form
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "antonov" <antonov@dds.nl> wrote in message
    > news:Etgcf.8116$OR3.6101@tornado.fastwebnet.it...
    >> The error is:
    >> "The text you entere isn't an item in the list.
    >> select an item from the list, or enter text that matches one of the
    >> listed
    >> items."
    >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    >> news:%23PTgcsK5FHA.2624@TK2MSFTNGP14.phx.gbl...
    >> > And do you get an error when you open it through the NotOnList event?
    >> > If
    >> > so,
    >> > what's the error?
    >> >
    >> > --
    >> > Doug Steele, Microsoft Access MVP
    >> > http://I.Am/DougSteele
    >> > (no e-mails, please!)
    >> >
    >> >
    >> > "antonov" <antonov@dds.nl> wrote in message
    >> > news:5m8cf.7799$OR3.5969@tornado.fastwebnet.it...
    >> >> yes, if I open the form on its own I can save the data
    >> >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
    >> >> message
    >> >> news:%23%23ssNPK5FHA.2092@TK2MSFTNGP12.phx.gbl...
    >> >> > What do you mean by "cannot save the data"? Do you get an error? If

    > you
    >> >> > open
    >> >> > the form on its own (i.e.: not from within the NotOnList event), can
    >> >> > you
    >> >> > save data?
    >> >> >
    >> >> > --
    >> >> > Doug Steele, Microsoft Access MVP
    >> >> > http://I.Am/DougSteele
    >> >> > (no e-mails, please!)
    >> >> >
    >> >> >
    >> >> > "antonov" <antonov@dds.nl> wrote in message
    >> >> > news:fU7cf.7726$OR3.6602@tornado.fastwebnet.it...
    >> >> >> here I am again..
    >> >> >> I have this form in which I can input data... I have a cbobox in

    > which
    >> >> > some
    >> >> >> data appears. On "on not on list" another form appears in edit mode
    >> >> >> and
    >> > I
    >> >> >> can insert some new data... but I cannot save the data.... can
    >> >> >> somebody
    >> >> >> please tell me why?
    >> >> >>
    >> >> >>
    >> >> >>
    >> >> >
    >> >> >
    >> >>
    >> >>
    >> >
    >> >

    >>
    >>

    >
    >
     
  11. antonov

    antonov
    Expand Collapse
    Guest

    ehmmm...
    I've created a macro ("add") which opens the form (edit mode) if the name is
    not in the combo...
    I've linked this macro to the cbobox if NotOnList... where do I add the code
    you wrote?
    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:uPKZbDS5FHA.2916@TK2MSFTNGP11.phx.gbl...
    > Sounds as though you've forgotten to include the line of code
    >
    > Response = acDataErrAdded
    >
    > in your NotInList event after the data has been added by the form
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "antonov" <antonov@dds.nl> wrote in message
    > news:Etgcf.8116$OR3.6101@tornado.fastwebnet.it...
    >> The error is:
    >> "The text you entere isn't an item in the list.
    >> select an item from the list, or enter text that matches one of the
    >> listed
    >> items."
    >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    >> news:%23PTgcsK5FHA.2624@TK2MSFTNGP14.phx.gbl...
    >> > And do you get an error when you open it through the NotOnList event?
    >> > If
    >> > so,
    >> > what's the error?
    >> >
    >> > --
    >> > Doug Steele, Microsoft Access MVP
    >> > http://I.Am/DougSteele
    >> > (no e-mails, please!)
    >> >
    >> >
    >> > "antonov" <antonov@dds.nl> wrote in message
    >> > news:5m8cf.7799$OR3.5969@tornado.fastwebnet.it...
    >> >> yes, if I open the form on its own I can save the data
    >> >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
    >> >> message
    >> >> news:%23%23ssNPK5FHA.2092@TK2MSFTNGP12.phx.gbl...
    >> >> > What do you mean by "cannot save the data"? Do you get an error? If

    > you
    >> >> > open
    >> >> > the form on its own (i.e.: not from within the NotOnList event), can
    >> >> > you
    >> >> > save data?
    >> >> >
    >> >> > --
    >> >> > Doug Steele, Microsoft Access MVP
    >> >> > http://I.Am/DougSteele
    >> >> > (no e-mails, please!)
    >> >> >
    >> >> >
    >> >> > "antonov" <antonov@dds.nl> wrote in message
    >> >> > news:fU7cf.7726$OR3.6602@tornado.fastwebnet.it...
    >> >> >> here I am again..
    >> >> >> I have this form in which I can input data... I have a cbobox in

    > which
    >> >> > some
    >> >> >> data appears. On "on not on list" another form appears in edit mode
    >> >> >> and
    >> > I
    >> >> >> can insert some new data... but I cannot save the data.... can
    >> >> >> somebody
    >> >> >> please tell me why?
    >> >> >>
    >> >> >>
    >> >> >>
    >> >> >
    >> >> >
    >> >>
    >> >>
    >> >
    >> >

    >>
    >>

    >
    >
     
  12. antonov

    antonov
    Expand Collapse
    Guest

    ehmmm...
    I've created a macro ("add") which opens the form (edit mode) if the name is
    not in the combo...
    I've linked this macro to the cbobox if NotOnList... where do I add the code
    you wrote?
    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:uPKZbDS5FHA.2916@TK2MSFTNGP11.phx.gbl...
    > Sounds as though you've forgotten to include the line of code
    >
    > Response = acDataErrAdded
    >
    > in your NotInList event after the data has been added by the form
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "antonov" <antonov@dds.nl> wrote in message
    > news:Etgcf.8116$OR3.6101@tornado.fastwebnet.it...
    >> The error is:
    >> "The text you entere isn't an item in the list.
    >> select an item from the list, or enter text that matches one of the
    >> listed
    >> items."
    >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    >> news:%23PTgcsK5FHA.2624@TK2MSFTNGP14.phx.gbl...
    >> > And do you get an error when you open it through the NotOnList event?
    >> > If
    >> > so,
    >> > what's the error?
    >> >
    >> > --
    >> > Doug Steele, Microsoft Access MVP
    >> > http://I.Am/DougSteele
    >> > (no e-mails, please!)
    >> >
    >> >
    >> > "antonov" <antonov@dds.nl> wrote in message
    >> > news:5m8cf.7799$OR3.5969@tornado.fastwebnet.it...
    >> >> yes, if I open the form on its own I can save the data
    >> >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
    >> >> message
    >> >> news:%23%23ssNPK5FHA.2092@TK2MSFTNGP12.phx.gbl...
    >> >> > What do you mean by "cannot save the data"? Do you get an error? If

    > you
    >> >> > open
    >> >> > the form on its own (i.e.: not from within the NotOnList event), can
    >> >> > you
    >> >> > save data?
    >> >> >
    >> >> > --
    >> >> > Doug Steele, Microsoft Access MVP
    >> >> > http://I.Am/DougSteele
    >> >> > (no e-mails, please!)
    >> >> >
    >> >> >
    >> >> > "antonov" <antonov@dds.nl> wrote in message
    >> >> > news:fU7cf.7726$OR3.6602@tornado.fastwebnet.it...
    >> >> >> here I am again..
    >> >> >> I have this form in which I can input data... I have a cbobox in

    > which
    >> >> > some
    >> >> >> data appears. On "on not on list" another form appears in edit mode
    >> >> >> and
    >> > I
    >> >> >> can insert some new data... but I cannot save the data.... can
    >> >> >> somebody
    >> >> >> please tell me why?
    >> >> >>
    >> >> >>
    >> >> >>
    >> >> >
    >> >> >
    >> >>
    >> >>
    >> >
    >> >

    >>
    >>

    >
    >
     
  13. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    You need to set the combobox's LimitToList property to Yes, and put code in
    its NotInList event.

    See http://www.mvps.org/access/forms/frm0015.htm at "The Access Web" for
    sample code.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "antonov" <antonov@dds.nl> wrote in message
    news:NYpcf.10768$OR3.513@tornado.fastwebnet.it...
    > ehmmm...
    > I've created a macro ("add") which opens the form (edit mode) if the name

    is
    > not in the combo...
    > I've linked this macro to the cbobox if NotOnList... where do I add the

    code
    > you wrote?
    > "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    > news:uPKZbDS5FHA.2916@TK2MSFTNGP11.phx.gbl...
    > > Sounds as though you've forgotten to include the line of code
    > >
    > > Response = acDataErrAdded
    > >
    > > in your NotInList event after the data has been added by the form
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > > "antonov" <antonov@dds.nl> wrote in message
    > > news:Etgcf.8116$OR3.6101@tornado.fastwebnet.it...
    > >> The error is:
    > >> "The text you entere isn't an item in the list.
    > >> select an item from the list, or enter text that matches one of the
    > >> listed
    > >> items."
    > >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    > >> news:%23PTgcsK5FHA.2624@TK2MSFTNGP14.phx.gbl...
    > >> > And do you get an error when you open it through the NotOnList event?
    > >> > If
    > >> > so,
    > >> > what's the error?
    > >> >
    > >> > --
    > >> > Doug Steele, Microsoft Access MVP
    > >> > http://I.Am/DougSteele
    > >> > (no e-mails, please!)
    > >> >
    > >> >
    > >> > "antonov" <antonov@dds.nl> wrote in message
    > >> > news:5m8cf.7799$OR3.5969@tornado.fastwebnet.it...
    > >> >> yes, if I open the form on its own I can save the data
    > >> >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
    > >> >> message
    > >> >> news:%23%23ssNPK5FHA.2092@TK2MSFTNGP12.phx.gbl...
    > >> >> > What do you mean by "cannot save the data"? Do you get an error?

    If
    > > you
    > >> >> > open
    > >> >> > the form on its own (i.e.: not from within the NotOnList event),

    can
    > >> >> > you
    > >> >> > save data?
    > >> >> >
    > >> >> > --
    > >> >> > Doug Steele, Microsoft Access MVP
    > >> >> > http://I.Am/DougSteele
    > >> >> > (no e-mails, please!)
    > >> >> >
    > >> >> >
    > >> >> > "antonov" <antonov@dds.nl> wrote in message
    > >> >> > news:fU7cf.7726$OR3.6602@tornado.fastwebnet.it...
    > >> >> >> here I am again..
    > >> >> >> I have this form in which I can input data... I have a cbobox in

    > > which
    > >> >> > some
    > >> >> >> data appears. On "on not on list" another form appears in edit

    mode
    > >> >> >> and
    > >> > I
    > >> >> >> can insert some new data... but I cannot save the data.... can
    > >> >> >> somebody
    > >> >> >> please tell me why?
    > >> >> >>
    > >> >> >>
    > >> >> >>
    > >> >> >
    > >> >> >
    > >> >>
    > >> >>
    > >> >
    > >> >
    > >>
    > >>

    > >
    > >

    >
    >
     
  14. antonov

    antonov
    Expand Collapse
    Guest

    ehmmm...
    I've created a macro ("add") which opens the form (edit mode) if the name is
    not in the combo...
    I've linked this macro to the cbobox if NotOnList... where do I add the code
    you wrote?
    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:uPKZbDS5FHA.2916@TK2MSFTNGP11.phx.gbl...
    > Sounds as though you've forgotten to include the line of code
    >
    > Response = acDataErrAdded
    >
    > in your NotInList event after the data has been added by the form
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "antonov" <antonov@dds.nl> wrote in message
    > news:Etgcf.8116$OR3.6101@tornado.fastwebnet.it...
    >> The error is:
    >> "The text you entere isn't an item in the list.
    >> select an item from the list, or enter text that matches one of the
    >> listed
    >> items."
    >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    >> news:%23PTgcsK5FHA.2624@TK2MSFTNGP14.phx.gbl...
    >> > And do you get an error when you open it through the NotOnList event?
    >> > If
    >> > so,
    >> > what's the error?
    >> >
    >> > --
    >> > Doug Steele, Microsoft Access MVP
    >> > http://I.Am/DougSteele
    >> > (no e-mails, please!)
    >> >
    >> >
    >> > "antonov" <antonov@dds.nl> wrote in message
    >> > news:5m8cf.7799$OR3.5969@tornado.fastwebnet.it...
    >> >> yes, if I open the form on its own I can save the data
    >> >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
    >> >> message
    >> >> news:%23%23ssNPK5FHA.2092@TK2MSFTNGP12.phx.gbl...
    >> >> > What do you mean by "cannot save the data"? Do you get an error? If

    > you
    >> >> > open
    >> >> > the form on its own (i.e.: not from within the NotOnList event), can
    >> >> > you
    >> >> > save data?
    >> >> >
    >> >> > --
    >> >> > Doug Steele, Microsoft Access MVP
    >> >> > http://I.Am/DougSteele
    >> >> > (no e-mails, please!)
    >> >> >
    >> >> >
    >> >> > "antonov" <antonov@dds.nl> wrote in message
    >> >> > news:fU7cf.7726$OR3.6602@tornado.fastwebnet.it...
    >> >> >> here I am again..
    >> >> >> I have this form in which I can input data... I have a cbobox in

    > which
    >> >> > some
    >> >> >> data appears. On "on not on list" another form appears in edit mode
    >> >> >> and
    >> > I
    >> >> >> can insert some new data... but I cannot save the data.... can
    >> >> >> somebody
    >> >> >> please tell me why?
    >> >> >>
    >> >> >>
    >> >> >>
    >> >> >
    >> >> >
    >> >>
    >> >>
    >> >
    >> >

    >>
    >>

    >
    >
     
  15. antonov

    antonov
    Expand Collapse
    Guest

    ehmmm...
    I've created a macro ("add") which opens the form (edit mode) if the name is
    not in the combo...
    I've linked this macro to the cbobox if NotOnList... where do I add the code
    you wrote?
    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:uPKZbDS5FHA.2916@TK2MSFTNGP11.phx.gbl...
    > Sounds as though you've forgotten to include the line of code
    >
    > Response = acDataErrAdded
    >
    > in your NotInList event after the data has been added by the form
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "antonov" <antonov@dds.nl> wrote in message
    > news:Etgcf.8116$OR3.6101@tornado.fastwebnet.it...
    >> The error is:
    >> "The text you entere isn't an item in the list.
    >> select an item from the list, or enter text that matches one of the
    >> listed
    >> items."
    >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    >> news:%23PTgcsK5FHA.2624@TK2MSFTNGP14.phx.gbl...
    >> > And do you get an error when you open it through the NotOnList event?
    >> > If
    >> > so,
    >> > what's the error?
    >> >
    >> > --
    >> > Doug Steele, Microsoft Access MVP
    >> > http://I.Am/DougSteele
    >> > (no e-mails, please!)
    >> >
    >> >
    >> > "antonov" <antonov@dds.nl> wrote in message
    >> > news:5m8cf.7799$OR3.5969@tornado.fastwebnet.it...
    >> >> yes, if I open the form on its own I can save the data
    >> >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
    >> >> message
    >> >> news:%23%23ssNPK5FHA.2092@TK2MSFTNGP12.phx.gbl...
    >> >> > What do you mean by "cannot save the data"? Do you get an error? If

    > you
    >> >> > open
    >> >> > the form on its own (i.e.: not from within the NotOnList event), can
    >> >> > you
    >> >> > save data?
    >> >> >
    >> >> > --
    >> >> > Doug Steele, Microsoft Access MVP
    >> >> > http://I.Am/DougSteele
    >> >> > (no e-mails, please!)
    >> >> >
    >> >> >
    >> >> > "antonov" <antonov@dds.nl> wrote in message
    >> >> > news:fU7cf.7726$OR3.6602@tornado.fastwebnet.it...
    >> >> >> here I am again..
    >> >> >> I have this form in which I can input data... I have a cbobox in

    > which
    >> >> > some
    >> >> >> data appears. On "on not on list" another form appears in edit mode
    >> >> >> and
    >> > I
    >> >> >> can insert some new data... but I cannot save the data.... can
    >> >> >> somebody
    >> >> >> please tell me why?
    >> >> >>
    >> >> >>
    >> >> >>
    >> >> >
    >> >> >
    >> >>
    >> >>
    >> >
    >> >

    >>
    >>

    >
    >
     
  16. antonov

    antonov
    Expand Collapse
    Guest

    ehmmm...
    I've created a macro ("add") which opens the form (edit mode) if the name is
    not in the combo...
    I've linked this macro to the cbobox if NotOnList... where do I add the code
    you wrote?
    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:uPKZbDS5FHA.2916@TK2MSFTNGP11.phx.gbl...
    > Sounds as though you've forgotten to include the line of code
    >
    > Response = acDataErrAdded
    >
    > in your NotInList event after the data has been added by the form
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "antonov" <antonov@dds.nl> wrote in message
    > news:Etgcf.8116$OR3.6101@tornado.fastwebnet.it...
    >> The error is:
    >> "The text you entere isn't an item in the list.
    >> select an item from the list, or enter text that matches one of the
    >> listed
    >> items."
    >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    >> news:%23PTgcsK5FHA.2624@TK2MSFTNGP14.phx.gbl...
    >> > And do you get an error when you open it through the NotOnList event?
    >> > If
    >> > so,
    >> > what's the error?
    >> >
    >> > --
    >> > Doug Steele, Microsoft Access MVP
    >> > http://I.Am/DougSteele
    >> > (no e-mails, please!)
    >> >
    >> >
    >> > "antonov" <antonov@dds.nl> wrote in message
    >> > news:5m8cf.7799$OR3.5969@tornado.fastwebnet.it...
    >> >> yes, if I open the form on its own I can save the data
    >> >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
    >> >> message
    >> >> news:%23%23ssNPK5FHA.2092@TK2MSFTNGP12.phx.gbl...
    >> >> > What do you mean by "cannot save the data"? Do you get an error? If

    > you
    >> >> > open
    >> >> > the form on its own (i.e.: not from within the NotOnList event), can
    >> >> > you
    >> >> > save data?
    >> >> >
    >> >> > --
    >> >> > Doug Steele, Microsoft Access MVP
    >> >> > http://I.Am/DougSteele
    >> >> > (no e-mails, please!)
    >> >> >
    >> >> >
    >> >> > "antonov" <antonov@dds.nl> wrote in message
    >> >> > news:fU7cf.7726$OR3.6602@tornado.fastwebnet.it...
    >> >> >> here I am again..
    >> >> >> I have this form in which I can input data... I have a cbobox in

    > which
    >> >> > some
    >> >> >> data appears. On "on not on list" another form appears in edit mode
    >> >> >> and
    >> > I
    >> >> >> can insert some new data... but I cannot save the data.... can
    >> >> >> somebody
    >> >> >> please tell me why?
    >> >> >>
    >> >> >>
    >> >> >>
    >> >> >
    >> >> >
    >> >>
    >> >>
    >> >
    >> >

    >>
    >>

    >
    >
     
  17. antonov

    antonov
    Expand Collapse
    Guest

    ehmmm...
    I've created a macro ("add") which opens the form (edit mode) if the name is
    not in the combo...
    I've linked this macro to the cbobox if NotOnList... where do I add the code
    you wrote?
    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:uPKZbDS5FHA.2916@TK2MSFTNGP11.phx.gbl...
    > Sounds as though you've forgotten to include the line of code
    >
    > Response = acDataErrAdded
    >
    > in your NotInList event after the data has been added by the form
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "antonov" <antonov@dds.nl> wrote in message
    > news:Etgcf.8116$OR3.6101@tornado.fastwebnet.it...
    >> The error is:
    >> "The text you entere isn't an item in the list.
    >> select an item from the list, or enter text that matches one of the
    >> listed
    >> items."
    >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    >> news:%23PTgcsK5FHA.2624@TK2MSFTNGP14.phx.gbl...
    >> > And do you get an error when you open it through the NotOnList event?
    >> > If
    >> > so,
    >> > what's the error?
    >> >
    >> > --
    >> > Doug Steele, Microsoft Access MVP
    >> > http://I.Am/DougSteele
    >> > (no e-mails, please!)
    >> >
    >> >
    >> > "antonov" <antonov@dds.nl> wrote in message
    >> > news:5m8cf.7799$OR3.5969@tornado.fastwebnet.it...
    >> >> yes, if I open the form on its own I can save the data
    >> >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
    >> >> message
    >> >> news:%23%23ssNPK5FHA.2092@TK2MSFTNGP12.phx.gbl...
    >> >> > What do you mean by "cannot save the data"? Do you get an error? If

    > you
    >> >> > open
    >> >> > the form on its own (i.e.: not from within the NotOnList event), can
    >> >> > you
    >> >> > save data?
    >> >> >
    >> >> > --
    >> >> > Doug Steele, Microsoft Access MVP
    >> >> > http://I.Am/DougSteele
    >> >> > (no e-mails, please!)
    >> >> >
    >> >> >
    >> >> > "antonov" <antonov@dds.nl> wrote in message
    >> >> > news:fU7cf.7726$OR3.6602@tornado.fastwebnet.it...
    >> >> >> here I am again..
    >> >> >> I have this form in which I can input data... I have a cbobox in

    > which
    >> >> > some
    >> >> >> data appears. On "on not on list" another form appears in edit mode
    >> >> >> and
    >> > I
    >> >> >> can insert some new data... but I cannot save the data.... can
    >> >> >> somebody
    >> >> >> please tell me why?
    >> >> >>
    >> >> >>
    >> >> >>
    >> >> >
    >> >> >
    >> >>
    >> >>
    >> >
    >> >

    >>
    >>

    >
    >
     
  18. antonov

    antonov
    Expand Collapse
    Guest

    ehmmm...
    I've created a macro ("add") which opens the form (edit mode) if the name is
    not in the combo...
    I've linked this macro to the cbobox if NotOnList... where do I add the code
    you wrote?
    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:uPKZbDS5FHA.2916@TK2MSFTNGP11.phx.gbl...
    > Sounds as though you've forgotten to include the line of code
    >
    > Response = acDataErrAdded
    >
    > in your NotInList event after the data has been added by the form
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "antonov" <antonov@dds.nl> wrote in message
    > news:Etgcf.8116$OR3.6101@tornado.fastwebnet.it...
    >> The error is:
    >> "The text you entere isn't an item in the list.
    >> select an item from the list, or enter text that matches one of the
    >> listed
    >> items."
    >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    >> news:%23PTgcsK5FHA.2624@TK2MSFTNGP14.phx.gbl...
    >> > And do you get an error when you open it through the NotOnList event?
    >> > If
    >> > so,
    >> > what's the error?
    >> >
    >> > --
    >> > Doug Steele, Microsoft Access MVP
    >> > http://I.Am/DougSteele
    >> > (no e-mails, please!)
    >> >
    >> >
    >> > "antonov" <antonov@dds.nl> wrote in message
    >> > news:5m8cf.7799$OR3.5969@tornado.fastwebnet.it...
    >> >> yes, if I open the form on its own I can save the data
    >> >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
    >> >> message
    >> >> news:%23%23ssNPK5FHA.2092@TK2MSFTNGP12.phx.gbl...
    >> >> > What do you mean by "cannot save the data"? Do you get an error? If

    > you
    >> >> > open
    >> >> > the form on its own (i.e.: not from within the NotOnList event), can
    >> >> > you
    >> >> > save data?
    >> >> >
    >> >> > --
    >> >> > Doug Steele, Microsoft Access MVP
    >> >> > http://I.Am/DougSteele
    >> >> > (no e-mails, please!)
    >> >> >
    >> >> >
    >> >> > "antonov" <antonov@dds.nl> wrote in message
    >> >> > news:fU7cf.7726$OR3.6602@tornado.fastwebnet.it...
    >> >> >> here I am again..
    >> >> >> I have this form in which I can input data... I have a cbobox in

    > which
    >> >> > some
    >> >> >> data appears. On "on not on list" another form appears in edit mode
    >> >> >> and
    >> > I
    >> >> >> can insert some new data... but I cannot save the data.... can
    >> >> >> somebody
    >> >> >> please tell me why?
    >> >> >>
    >> >> >>
    >> >> >>
    >> >> >
    >> >> >
    >> >>
    >> >>
    >> >
    >> >

    >>
    >>

    >
    >
     
  19. antonov

    antonov
    Expand Collapse
    Guest

    ehmmm...
    I've created a macro ("add") which opens the form (edit mode) if the name is
    not in the combo...
    I've linked this macro to the cbobox if NotOnList... where do I add the code
    you wrote?
    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:uPKZbDS5FHA.2916@TK2MSFTNGP11.phx.gbl...
    > Sounds as though you've forgotten to include the line of code
    >
    > Response = acDataErrAdded
    >
    > in your NotInList event after the data has been added by the form
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "antonov" <antonov@dds.nl> wrote in message
    > news:Etgcf.8116$OR3.6101@tornado.fastwebnet.it...
    >> The error is:
    >> "The text you entere isn't an item in the list.
    >> select an item from the list, or enter text that matches one of the
    >> listed
    >> items."
    >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    >> news:%23PTgcsK5FHA.2624@TK2MSFTNGP14.phx.gbl...
    >> > And do you get an error when you open it through the NotOnList event?
    >> > If
    >> > so,
    >> > what's the error?
    >> >
    >> > --
    >> > Doug Steele, Microsoft Access MVP
    >> > http://I.Am/DougSteele
    >> > (no e-mails, please!)
    >> >
    >> >
    >> > "antonov" <antonov@dds.nl> wrote in message
    >> > news:5m8cf.7799$OR3.5969@tornado.fastwebnet.it...
    >> >> yes, if I open the form on its own I can save the data
    >> >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
    >> >> message
    >> >> news:%23%23ssNPK5FHA.2092@TK2MSFTNGP12.phx.gbl...
    >> >> > What do you mean by "cannot save the data"? Do you get an error? If

    > you
    >> >> > open
    >> >> > the form on its own (i.e.: not from within the NotOnList event), can
    >> >> > you
    >> >> > save data?
    >> >> >
    >> >> > --
    >> >> > Doug Steele, Microsoft Access MVP
    >> >> > http://I.Am/DougSteele
    >> >> > (no e-mails, please!)
    >> >> >
    >> >> >
    >> >> > "antonov" <antonov@dds.nl> wrote in message
    >> >> > news:fU7cf.7726$OR3.6602@tornado.fastwebnet.it...
    >> >> >> here I am again..
    >> >> >> I have this form in which I can input data... I have a cbobox in

    > which
    >> >> > some
    >> >> >> data appears. On "on not on list" another form appears in edit mode
    >> >> >> and
    >> > I
    >> >> >> can insert some new data... but I cannot save the data.... can
    >> >> >> somebody
    >> >> >> please tell me why?
    >> >> >>
    >> >> >>
    >> >> >>
    >> >> >
    >> >> >
    >> >>
    >> >>
    >> >
    >> >

    >>
    >>

    >
    >
     
  20. antonov

    antonov
    Expand Collapse
    Guest

    Douglas,
    I've copied the exampe in the "The Access Web" you told me...
    the only thing is that I cannot open the form (Consignee) I need to open in
    order to input the data needed....
    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:uhTpYIV5FHA.3880@TK2MSFTNGP12.phx.gbl...
    > You need to set the combobox's LimitToList property to Yes, and put code
    > in
    > its NotInList event.
    >
    > See http://www.mvps.org/access/forms/frm0015.htm at "The Access Web" for
    > sample code.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "antonov" <antonov@dds.nl> wrote in message
    > news:NYpcf.10768$OR3.513@tornado.fastwebnet.it...
    >> ehmmm...
    >> I've created a macro ("add") which opens the form (edit mode) if the name

    > is
    >> not in the combo...
    >> I've linked this macro to the cbobox if NotOnList... where do I add the

    > code
    >> you wrote?
    >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    >> news:uPKZbDS5FHA.2916@TK2MSFTNGP11.phx.gbl...
    >> > Sounds as though you've forgotten to include the line of code
    >> >
    >> > Response = acDataErrAdded
    >> >
    >> > in your NotInList event after the data has been added by the form
    >> >
    >> > --
    >> > Doug Steele, Microsoft Access MVP
    >> > http://I.Am/DougSteele
    >> > (no e-mails, please!)
    >> >
    >> >
    >> > "antonov" <antonov@dds.nl> wrote in message
    >> > news:Etgcf.8116$OR3.6101@tornado.fastwebnet.it...
    >> >> The error is:
    >> >> "The text you entere isn't an item in the list.
    >> >> select an item from the list, or enter text that matches one of the
    >> >> listed
    >> >> items."
    >> >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
    >> >> message
    >> >> news:%23PTgcsK5FHA.2624@TK2MSFTNGP14.phx.gbl...
    >> >> > And do you get an error when you open it through the NotOnList
    >> >> > event?
    >> >> > If
    >> >> > so,
    >> >> > what's the error?
    >> >> >
    >> >> > --
    >> >> > Doug Steele, Microsoft Access MVP
    >> >> > http://I.Am/DougSteele
    >> >> > (no e-mails, please!)
    >> >> >
    >> >> >
    >> >> > "antonov" <antonov@dds.nl> wrote in message
    >> >> > news:5m8cf.7799$OR3.5969@tornado.fastwebnet.it...
    >> >> >> yes, if I open the form on its own I can save the data
    >> >> >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
    >> >> >> message
    >> >> >> news:%23%23ssNPK5FHA.2092@TK2MSFTNGP12.phx.gbl...
    >> >> >> > What do you mean by "cannot save the data"? Do you get an error?

    > If
    >> > you
    >> >> >> > open
    >> >> >> > the form on its own (i.e.: not from within the NotOnList event),

    > can
    >> >> >> > you
    >> >> >> > save data?
    >> >> >> >
    >> >> >> > --
    >> >> >> > Doug Steele, Microsoft Access MVP
    >> >> >> > http://I.Am/DougSteele
    >> >> >> > (no e-mails, please!)
    >> >> >> >
    >> >> >> >
    >> >> >> > "antonov" <antonov@dds.nl> wrote in message
    >> >> >> > news:fU7cf.7726$OR3.6602@tornado.fastwebnet.it...
    >> >> >> >> here I am again..
    >> >> >> >> I have this form in which I can input data... I have a cbobox in
    >> > which
    >> >> >> > some
    >> >> >> >> data appears. On "on not on list" another form appears in edit

    > mode
    >> >> >> >> and
    >> >> > I
    >> >> >> >> can insert some new data... but I cannot save the data.... can
    >> >> >> >> somebody
    >> >> >> >> please tell me why?
    >> >> >> >>
    >> >> >> >>
    >> >> >> >>
    >> >> >> >
    >> >> >> >
    >> >> >>
    >> >> >>
    >> >> >
    >> >> >
    >> >>
    >> >>
    >> >
    >> >

    >>
    >>

    >
    >
     
  21. antonov

    antonov
    Expand Collapse
    Guest

    ehmmm...
    I've created a macro ("add") which opens the form (edit mode) if the name is
    not in the combo...
    I've linked this macro to the cbobox if NotOnList... where do I add the code
    you wrote?
    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:uPKZbDS5FHA.2916@TK2MSFTNGP11.phx.gbl...
    > Sounds as though you've forgotten to include the line of code
    >
    > Response = acDataErrAdded
    >
    > in your NotInList event after the data has been added by the form
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "antonov" <antonov@dds.nl> wrote in message
    > news:Etgcf.8116$OR3.6101@tornado.fastwebnet.it...
    >> The error is:
    >> "The text you entere isn't an item in the list.
    >> select an item from the list, or enter text that matches one of the
    >> listed
    >> items."
    >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    >> news:%23PTgcsK5FHA.2624@TK2MSFTNGP14.phx.gbl...
    >> > And do you get an error when you open it through the NotOnList event?
    >> > If
    >> > so,
    >> > what's the error?
    >> >
    >> > --
    >> > Doug Steele, Microsoft Access MVP
    >> > http://I.Am/DougSteele
    >> > (no e-mails, please!)
    >> >
    >> >
    >> > "antonov" <antonov@dds.nl> wrote in message
    >> > news:5m8cf.7799$OR3.5969@tornado.fastwebnet.it...
    >> >> yes, if I open the form on its own I can save the data
    >> >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
    >> >> message
    >> >> news:%23%23ssNPK5FHA.2092@TK2MSFTNGP12.phx.gbl...
    >> >> > What do you mean by "cannot save the data"? Do you get an error? If

    > you
    >> >> > open
    >> >> > the form on its own (i.e.: not from within the NotOnList event), can
    >> >> > you
    >> >> > save data?
    >> >> >
    >> >> > --
    >> >> > Doug Steele, Microsoft Access MVP
    >> >> > http://I.Am/DougSteele
    >> >> > (no e-mails, please!)
    >> >> >
    >> >> >
    >> >> > "antonov" <antonov@dds.nl> wrote in message
    >> >> > news:fU7cf.7726$OR3.6602@tornado.fastwebnet.it...
    >> >> >> here I am again..
    >> >> >> I have this form in which I can input data... I have a cbobox in

    > which
    >> >> > some
    >> >> >> data appears. On "on not on list" another form appears in edit mode
    >> >> >> and
    >> > I
    >> >> >> can insert some new data... but I cannot save the data.... can
    >> >> >> somebody
    >> >> >> please tell me why?
    >> >> >>
    >> >> >>
    >> >> >>
    >> >> >
    >> >> >
    >> >>
    >> >>
    >> >
    >> >

    >>
    >>

    >
    >
     

Share This Page