Value in a Combo Box as a Variable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I take the value from a Combo Box and turn it into a variable so I can
update a table in a SQL database?
 
Concatenate its value into an SQL string that you build in code.

or

Write a public function that reads the value in the combo box and returns it
as the value of the function; call this function from a query (assumes that
you're running the query in the ACCESS front end).
 
For numeric fields:
strSQL = "SELECT * FROM MyTable WHERE [FieldName]=" & Me.ComboboxName.Value


For text fields:
strSQL = "SELECT * FROM MyTable WHERE [FieldName]='" & Me.ComboboxName.Value
& "'"

--

Ken Snell
<MS ACCESS MVP>
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Undo a combo box selection 3
conditional update of checkbox dependent on combo box in separate. 5
Combo Box On Click 6
Locking a combo box 4
Update Combo Box 4
add SQL query to report or otherwise enable to produce a report fr 4
Need combo box to refresh when moving to new record 2017 1
Combo Box & Report Questions 22

Back
Top