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