adding information (A2000)

Topic

New Reply

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

Reply | Quote

Replies

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?

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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 ?

Reply | Quote