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

Combobox using maybe onchange event

P: 2
I have a form on access database where I can select a field from a combo box. I'd like to add a procedure or a macro to accept any change that I have made to that field. How can I do this. It's seems simple but I'm new in access. Do I have to use onchange event? Is there any procedure or macro that I can use to solve this question? I what to select the possible acceptance or not to the change off the field.
Nov 21 '06 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
I have a form on access database where I can select a field from a combo box. I'd like to add a procedure or a macro to accept any change that I have made to that field. How can I do this. It's seems simple but I'm new in access. Do I have to use onchange event? Is there any procedure or macro that I can use to solve this question? I what to select the possible acceptance or not to the change off the field.
This totally depends on what your combobox is based on. A "Value List" or a "Table/Query".

Either way though it's not a good idea to change the value in this way.

Why do you want the user to be able to change the value. Comboboxes are usually used to limit the value choices of the user and although it is common to add to those choices or delete one of them. It is unusual to just edit the value and I can't think why you would want to.

It sounds like you should be using something other than a combo box like a subform.

Anyway if you can tell me what you are trying to do and why we should be able to come up with a solution.
Nov 21 '06 #2

P: 2
This totally depends on what your combobox is based on. A "Value List" or a "Table/Query".

Either way though it's not a good idea to change the value in this way.

Why do you want the user to be able to change the value. Comboboxes are usually used to limit the value choices of the user and although it is common to add to those choices or delete one of them. It is unusual to just edit the value and I can't think why you would want to.

It sounds like you should be using something other than a combo box like a subform.

Anyway if you can tell me what you are trying to do and why we should be able to come up with a solution.

I have the "not in list event" procedure In that combobox, because I have to add or edit some fields from that combo box to another table, otherwise I have to close the form and then go to the table that a want to add or edit some fields, and then return to the form I previously close. In that way I can modify the combo box. I need a procedure or macro (maybe "on change event") to accept or decline any changes that I have made to that field. The not in list event only advise me to accept or not if the field that I enter was diferent than the others that already was in the table. I'd like to add different names to that field than the previosly that was there and be notify to accept or not. The combobox was made from a Table.

Thanks.
Nov 21 '06 #3

Post your reply

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