Hi, if I connected access data base to vb form and I want to insert value of dropdown list(Items are yes and no) into the data base (field is type of Yes/No) what will be the insert statement?!
q8_dreamy
-1
Light Poster
Recommended Answers
Jump to Postpost your code...
Jump to Postyou have dropdownlist with value Yes and No. you want to insert selected value in dropdownlist to db.
cmcontact.CommandText = "INSERT INTO TableName(ColumnName) VALUES('" & Me.DropDownList1.SelectedValue & "')"
What kind of error was come?
Jump to PostI got :
Syntax Error in Insert statementare you have tried my code in previous post??
All 9 Replies
Jx_Man
987
Nearly a Senior Poster
Featured Poster
q8_dreamy
-1
Light Poster
Jx_Man
987
Nearly a Senior Poster
Featured Poster
q8_dreamy
-1
Light Poster
Jx_Man
987
Nearly a Senior Poster
Featured Poster
q8_dreamy
-1
Light Poster
Jx_Man
987
Nearly a Senior Poster
Featured Poster
q8_dreamy
-1
Light Poster
Jx_Man
987
Nearly a Senior Poster
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.