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

combobox update

P: n/a
Hello, i have a problem with a query that update a table with the combo
value and i have n combo. Ok, but when i don't insert any value in one
combobox and run the query, all the value are insert in the table also
the blank value that i don' t want to be update. The query that i use
is:

UPDATE [MD TBL02 - GENERAL SKILLS] SET [MD TBL02 - GENERAL
SKILLS].[Microsoft Excel] = Forms![FORM01 - Input]!Combo_Excel, [MD
TBL02 - GENERAL SKILLS].[Microsoft Access] = Forms![FORM01 -
Input]!Combo_Access, [MD TBL02 - GENERAL SKILLS].[Microsoft
PowerPoint] = Forms![FORM01 - Input]!Combo_PowerPoint, [MD TBL02 -
GENERAL SKILLS].[Microsoft Project] = Forms![FORM01 -
Input]!Combo_Project, [MD TBL02 - GENERAL SKILLS].[Business English] =
Forms![FORM01 - Input]!Combo_English, [MD TBL02 - GENERAL
SKILLS].[Sap Financial Courses] = Forms![FORM01 -
Input]!Combo_SAP_Financial, [MD TBL02 - GENERAL SKILLS].[Sap
Controlling] = Forms![FORM01 - Input]!Combo_SAP_Controlling, [MD TBL02
- GENERAL SKILLS].[Sap Fi/CO Base] = Forms![FORM01 -
Input]!Combo_SAP_FICO, [MD TBL02 - GENERAL SKILLS].[Sap BW R&A] =
Forms![FORM01 - Input]!Combo_SAP_BW, [MD TBL02 - GENERAL
SKILLS].[Additional Needs] = Forms![FORM01 - Input]!Txt_GenSkill_Needs
WHERE (((Forms![FORM01 - Input]!Combo_Excel)<>"") And (([MD TBL02 -
GENERAL SKILLS].EmplID)=Forms![FORM01 - Input]!EmplID_Selection));

i insert a WHERE but the result is the same.
example: I inset all the value and leave blank the combo_Excel,
i update and the old date insert are replace with the new value and
also the blank value of the combo that i leave blank

Tnx for help

Dec 4 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

Sasa wrote:
Hello, i have a problem with a query that update a table with the combo
value and i have n combo. Ok, but when i don't insert any value in one
combobox and run the query, all the value are insert in the table also
the blank value that i don' t want to be update. The query that i use
is:

UPDATE [MD TBL02 - GENERAL SKILLS] SET [MD TBL02 - GENERAL
SKILLS].[Microsoft Excel] = Forms![FORM01 - Input]!Combo_Excel, [MD
TBL02 - GENERAL SKILLS].[Microsoft Access] = Forms![FORM01 -
Input]!Combo_Access, [MD TBL02 - GENERAL SKILLS].[Microsoft
PowerPoint] = Forms![FORM01 - Input]!Combo_PowerPoint, [MD TBL02 -
GENERAL SKILLS].[Microsoft Project] = Forms![FORM01 -
Input]!Combo_Project, [MD TBL02 - GENERAL SKILLS].[Business English] =
Forms![FORM01 - Input]!Combo_English, [MD TBL02 - GENERAL
SKILLS].[Sap Financial Courses] = Forms![FORM01 -
Input]!Combo_SAP_Financial, [MD TBL02 - GENERAL SKILLS].[Sap
Controlling] = Forms![FORM01 - Input]!Combo_SAP_Controlling, [MD TBL02
- GENERAL SKILLS].[Sap Fi/CO Base] = Forms![FORM01 -
Input]!Combo_SAP_FICO, [MD TBL02 - GENERAL SKILLS].[Sap BW R&A] =
Forms![FORM01 - Input]!Combo_SAP_BW, [MD TBL02 - GENERAL
SKILLS].[Additional Needs] = Forms![FORM01 - Input]!Txt_GenSkill_Needs
WHERE (((Forms![FORM01 - Input]!Combo_Excel)<>"") And (([MD TBL02 -
GENERAL SKILLS].EmplID)=Forms![FORM01 - Input]!EmplID_Selection));

i insert a WHERE but the result is the same.
example: I inset all the value and leave blank the combo_Excel,
i update and the old date insert are replace with the new value and
also the blank value of the combo that i leave blank

Tnx for help
To insert values into a table through a combobox, you need to use the
On Not In List event. Have a look eithert here on in the help for
examples.

Dec 4 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.