Solved

ms access + combo box on click - value to textbox

Posted on 2011-02-11
2
386 Views
Last Modified: 2012-05-11
i am using access 2010, and would like to have a combo box and text field on a form, i would ilke when the user selects a value from the combo box, it adds it to the value of the text box, so the user can add several values, the value would be seperated by commas. I am thinking of using a macro - with an after update event, but not sure how to append to the value already in the text box.
0
Comment
Question by:dkilby
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 34874441
use the afterupdate event of the combo

private sub combo0_afterupdate()
dim str as string
str=str & me.combo0

me.text1=me.text1 & str & ","

end sub
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34874523
or this one

private sub combo0_afterupdate()
dim str as string
str=str & me.combo0

if me.text1 & ""="" then
     me.text1=str
     else
     me.text1=me.text1 & "," & str
end if
end sub
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question