I hate it when I can't do it my self....Thanks a lot, it works like a charm!
I had another solution for unbound Combo and List Boxes together with a query...you can add a refresh button so every time you update the comboBox you hit the refresh so you get a requery in the list BOX -- just a stupid ideea "but" I was about to go ahead with it :))
Thank you!
PS: if you have a banner please send it my way...
bimos
Last Activity: Feb 22 '07, 03:04 PM
Joined: Feb 20 '07
Location: Brusseles
-
Silly Me :) should have done this in the 1st place
ComboBox rowsource ->SELECT[List of Companies].[company key];[List of Companies].[Company Name] FROM[List of Companies]
The Control source is Company Key
List Box-> SELECT CompContactQ.Na me FROM CompContactQ;
The control source is Contact Key
The Query SQL is :
SELECT [Company Contacts].Name
FROM[List...Leave a comment:
-
Well I have taken a look at the Tutorial great one! The problem is that my Combo and my list box are bound to FK fields in one table :(
...Code:Private Sub ComboBOX_AfterUpdate() With Me![List12] >>>[U]Is my list Box[/U] If IsNull(Me!ComboBOX) Then .RowSource = " " Else .RowSource = "SELECT [Name]" & _ "FROM CompanyContactQ " & _ >>>[U]The[/]Leave a comment:
-
List Box Population :))
New day new Problem
I have a Combo Box - a query - and a list box
What I want to do is:
User selects a value in the combobox the query runs and the output is shown in the list box
I have managed to output the first result but when i select another value in the ComboBox ---> nada ....I get the same result!
I know there is a after update issue but I'm a no coder :( still I'll do my best if needed!... -
I'll handle it from here!
Subreports are not cool but they do the job :)
Thanks for everything
Thank You!
PS if you need anything just PM :)Leave a comment:
-
Thank you !
It works ok , the only problem now is that I can see only one comment or date!
Is this a grouping setting that I miss?
AlexLeave a comment:
-
Yes
I fixed it somehow. The problem was a nasty wizard!
I used it to create the combo box and it was creating a bad "row source" :)
Thanks, hope you can give me a hand with the report grouping!!!
Have a super Day :)Leave a comment:
-
Sure here it is
...Code:SELECT[List of Companies].[Company Name],[List of Products].Product, [Company Comments].[Date entered], [Company Comments].Comment FROM ([List of Products] INNER JOIN ([List of Companies] INNER JOIN [Company Demand] ON[List of Companies].[Company Key] = [Company Demand].[Company Key]) ON[List of Products].[Product Key] = [Company Demand].[Product Key]) INNER JOIN [Company Comments] ON[List of Companies].[Company
Leave a comment:
-
Report duplicates
Second issue of the day ...
I have a report submitted to a query
In the report I should have Company, many products, many dates and comments.
The problem is I always end up with duplicates.
Isn't there a way to "hide duplicates" for each group???
How can I solve this problem ???
Hope someone can spare 2 micro seconds for me! -
...Code:SELECT[List of Companies].[Company Name],[List of Products].Product, [Company Comments].[Date entered], [Company Comments].Comment FROM ([List of Products] INNER JOIN ([List of Companies] INNER JOIN [Company Demand] ON[List of Companies].[Company Key] = [Company Demand].[Company Key]) ON[List of Products].[Product Key] = [Company Demand].[Product Key]) INNER JOIN [CompanyLeave a comment:
-
Combo Mess
Help
I have a big problem:
I have a query with a criteria that should be set from a comboBox located on a form .
The problem I have is that when I select the value in the comboBox it doesn't run the query with the value that I select ...I just get a blank query result.
I know it's easy but I just can't make it work!!!
I am a zero when it comes to code but I'll do my best if there is no...
No activity results to display
Leave a comment: