var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Combo box to query, displayed in text box.
I fairly new to access and am working on a project.
What I need is a combo box that supplies data to a query, and then display the results of the query in a text box.
I have the combo box and query working properly, I just dont know how to get the query to show up in the text box once something is selected in the combo box.
Link your form on this query.
I linked the entire form to the query, but nothing different happens.
Let me try to explain my circumstances a little better.
Lets say I'm working with a music database.
Table1 is Artists containing the artistid and artist
Table2 is Tracks containing trackid artistid and songtitle
I have form1 with a combobox that pulls its contents from Artist table and displays the artists
I have a query that displays the songtitle's for all the songs that is by the selected artist from the combo box.
What I need is a text box to filled with the results of the query whenever the combo box is changed.
For example if i select Michael Jackson in the combo box, the text box may contain Thriller, Beet It, and Billy Jean. If I move to a different artist the combo box needs to then display that data.
Ive gotten this to work a little bit using the dlookup function.
The problem I am having is that it only will display 1 result.
I need it to display every result in the query.
Any ideas on how to accomplish this?
Send a short example of your mdb. Access 2000 or 2002.
I got this figured out somewhat.
What I did was add a select query to the row source of my text box and then use some VBA to make it refresh.
The problem I am having now is trying to add an "ALL" to my combo box that selects all records, but I will start another thread for that.
Private Sub Combo_AfterUpdate()
Tags for this Thread