Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    London, Gtr London, United Kingdom
    Posts
    153
    Thanks
    0
    Thanked 0 Times in 0 Posts

    adding information (A2000)

    Good morning

    On a form I have certain fields (based on lookups from other fields) that I would like the user to be able to enter information into and get a message box asking whether they wish to save the new information or not. I am able to do this so that the information is always retained in the underlying / source form. What I would like to do, if it is possible is if the user selects 'no' from the message box the information is saved to the form in use but not to the underlying / source form.

    Can anybody help please

    Steve

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: adding information (A2000)

    You will have to provide more information. What kind of control are you using - a combo box or a text box? How does the lookup work and how do you save the new information now?

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: adding information (A2000)

    Do you have more than one form ? Are they based on the same tables/queries ?
    You can't save data into a form. Only into tables.
    Can you provide some more specific info ?
    Francois

  4. #4
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    London, Gtr London, United Kingdom
    Posts
    153
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: adding information (A2000)

    Thanks for both response,

    This is what currently happens and what I would like to happen

    FrmAWB has a field Goods that looks up information from FrmGoods using the following on the

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: adding information (A2000)

    Let's get the terminology straight first. As Francois already remarked, you don't store a value in FrmGoods, you store it in the table FrmGoods is based on.

    Your wish is contradictory.

    If you set the Limit to List property of a combo box to No, the user can enter text that is not a list item. You can use this value just as it it were a list item, but it will not be added to the underlying table.

    If you set Limit to List to Yes, the user can only select items from the list. If he/she enters a value that is not in the list, the On Not In List event occurs, and you can let the user decide whether the new value should be added to the list (=table) or not. You can't keep the value, yet NOT add it to the list. That is precisely what the Limit to List = Yes property is designed to prevent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •