Prevent Users from deleting the values after update of combo box

[mba_110]

Hi Everyone there.

I want to prevent users from deleting the selected value in combo box or from editing it.

I am using find first function for records with combo box and when i delete the selected value in combo box it also deleting the record from table, which i dont want to be happen.

So, can you please mention any procedure or event to prevent the deletion or edition to combo box selected value.

i have made following fields options for combo box.

Allow value list edits = No
Limit to list = Yes

Temporary i have taken out the NZ function from my find first but its also giving error message when i delete the combo box value.

 

[June7]

It should not be deleting record, just value from field.

Controls used for input of search criteria should be UNBOUND.

 

[mba_110]

My combo box is getting records from query and query have tables fields selected.

I am filtering some data in combo box from the query hence, its deleting the information.

 

[June7]

Okay, this is a well-known issue of cascading/dependent comboboxes that have lookup alias. If item is not in combobox list, then the alias is not available for display. It's especially aggravating on continuous or datasheet form. There are many threads in many forums discussing this.

Review http://www.rogersaccesslibrary.com/...subformmdb-intermediate_topic388_post388.html