List box not reflecting change on a form

[vladimir.tz]

Hi all,
This is my first post here, I apologize for my English since it is my second language...

Here is my problem: I have a form (based on query) which shows all the invoices for certain category of contracts. In this category, there is about 20 contracts and about 150 invoices. There is a listbox on the form and users can browse thru the invoices by finding them on that listbox.
I also have a combobox with all the contracts so users can select certain contract to filter invoices for that contract only.
All that is working fine, but my listbox will always show ALL the invoices regardless of combo selection. I want listbox to show invoices only for contract selected via combobox.


I am not a access novice and will try to help others with their problems but now I need help on this one.

Thanks in advance!!!

[pbaldy]

That would be the same concept as this:

http://www.baldyweb.com/CascadingCombo.htm

[vladimir.tz]

Thanks for your fast response.

where do I put this:

strSource = "SELECT City " & _
"FROM Cities " & _
"WHERE State = '" & Me.cboState2 & "' ORDER BY City"
Me.cboCities2.RowSource = strSource
Me.cboCities2 = vbNullString

Also, when I open my form, the listbox will show al the invoices. Then, after combobox selection, the listbox should reflect that change (and show invoices for selected contract only).

[vladimir.tz]

OK, this is my SQL for the listbox:
SELECT [QRY - Invoice TO002 bycontractNEW].[Invoice Number]
FROM [QRY - Invoice TO002 bycontractNEW]
WHERE ((([QRY - Invoice TO002 bycontractNEW].[Contract Number])=[Forms]![Combo57]![Contract Number]));

QRY - Invoice TO002 bycontractNEW is where my information is coming from.

Combo57 is where users select the contract
List45 is name of the listbox.

This is code behind Combo57:

Private Sub Combo57_AfterUpdate()
If Not IsNull(Me.Combo57) Then
Me.FilterOn = True
Me.Filter = "[Contract Number] ='" & Me.Combo57 & "'"
Else
Me.FilterOn = False
End If
End Sub


Every time I open my form, I receive Enter Parameter Value: Forms!FRM - Invoices TO0002 by contractNEW!Contract Number

[pbaldy]

If you want to show all records when the form opens, then don't use a criteria. Your form reference syntax is wrong:

Forms Refer to Form and Subform properties and controls

[vladimir.tz]

If you want to show all records when the form opens, then don't use a criteria. Your form reference syntax is wrong:

Forms Refer to Form and Subform properties and controls

Well, I do not want form to show all records, I am telling you what is happening to my form now. When I open form, all invoices are listed in the listbox. When I go to the combox and select contract number, the form will show invoices for that contract but the list box is still showing ALL invoices.

I appreciate your efforts to help me out.
Greetings from Middle East

[pbaldy]

I realize that; I said when the form opens. That link demonstrated two methods of updating the listbox. Given what I assume is the desire for the listbox to show all records when the form opens, I'd use the method that changes its row source. The code you posted in #4 is filtering the form, not the listbox.

[Ruby16]

Hi all,
This is my first post here, I apologize for my English since it is my second language...

Here is my problem: I have a form (based on query) which shows all the invoices for certain category of contracts. In this category, there is about 20 contracts and about 150 invoices. There is a listbox on the form and users can browse thru the invoices by finding them on that listbox.
I also have a combobox with all the contracts so users can select certain contract to filter invoices for that contract only.
All that is working fine, but my listbox will always show ALL the invoices regardless of combo selection. I want listbox to show invoices only for contract selected via combobox.
I am not a access novice and will try to help others with their problems but now I need help on this one.

Thanks in advance!!!

I found a site that would help you try it Sample forms