By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,568 Members | 1,688 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,568 IT Pros & Developers. It's quick & easy.

delete combobox entry on access datasheet

P: 3
My datasheet form has a combo box which is set to Yes for the Limit to List property.
The user should enter a blank or an item on the list.
When they enter an item on the list and then blank it out, it blanks out the item name of the item that was selected, in the source table.

I will like that the following happens rather:
-The combobox should allow blanks.
-if an item on the list is selected by the user and thereafter deleted, the combobox should not edit the list and make the list item blank.

I do not want a blank to be part of the drop down list as a selectable option.

Is this possible? please help
May 16 '15 #1
Share this Question
Share on Google+
6 Replies


Seth Schrock
Expert 2.5K+
P: 2,951
Try setting the Allow Value List Edits to No.
May 16 '15 #2

P: 3
Thanks for the reply Seth. that setting is already set to no...
Anything else that I may be overlooking?
May 17 '15 #3

Rabbit
Expert Mod 10K+
P: 12,430
This doesn't make sense. They select a combo box item. Then they blank it out, presumably by deleting what's in the combo box. But you want the value to continue being in the combo box? I'm missing something.
May 17 '15 #4

zmbd
Expert Mod 5K+
P: 5,397
richmoumakwe:
Open your form in design view.
Press {ALT}{ENTER} to open the properties sheet.
Either select the control in your form, or select the control name from the dropdown list.
[Data] Tab... what do you in the following properties
[Control Source] :=
[Row Source] :=
[Row Source Type] :=
[Bound Column] :=

[Event tab]
[Before Update] :=
[After Update] :=
... any other events?
May 18 '15 #5

P: 3
Hi all,

Firstly thank you all for the support in trying to figure out the solution for me. I now know what the problem was:
The form is based on a query.
This query has multiple tables linked to it.
When I created the combo box I looked up the full name from the list and that automatically updates any changes back to the source table.
What I should have done was not link the query to other tables. that way the user cannot edit the source list through a combo box.

I hope that this makes sense?

Regards
Jun 18 '15 #6

zmbd
Expert Mod 5K+
P: 5,397
that makes sense.
there are ways to prevent editing values in the CBO both via properties and in code should you think those methods would prove useful for you in this situation.
Jun 18 '15 #7

Post your reply

Sign in to post your reply or Sign up for a free account.