Update QUERY

[FiDz]

Hello All;
am new to VBA and Access
I have a situation where i have two combo boxes (named a , b)
when the user select an item from combo "a", i want to load some values from a table and load them into combo box 'b"

how can i insert value of the combo box into the Query? can anyone please provide an example?

another question, how can i pass a parameter to a report (when opering it) how's the button's calling the report should be coded, and the report, how can it get it?

[RobDog888]

Answer to Q#2:

Application.DoCmd.OpenReport "TestQuestions", acViewPreview, ,"WHERE Something = 'Somethingelse'", acWindowNormal

Answer to Q#1:

Option Explicit
 
Private Sub Combo1_Click()
    Call PopulateCBO
End Sub
 
Private Sub Combo1_KeyUp(KeyCode As Integer, Shift As Integer)
    Call PopulateCBO
End Sub
 
Private Function PopulateCBO()
 
    'Using your previously populated recordset from database
    With Combo2
        DoEvents
        .Clear
        Do While RS.EOF = False
            .AddItem RS.Fields("Field1").Value
            RS.MoveNext
        Loop
    End With
    
End Function

[FiDz]

Thanks,
As for question 1:
i need to update the recodSource as follows:
select OfferID from Offers Where X = THE VALUE OF THE SELECTED COMBO!

whats the exact statement of it ?

[RobDog888]

To retrieve the selected items?

"SELECT OfferID FROM Offers WHERE X = '" & Combo1.Text & "'"

To update the selected item with a value from combo 2?

"UPDATE Table1 SET Field1 = '" & Combo2.Text & "' WHERE Field1 = '" & Combo1.Text & "'"

Not sure how you need them to work, but those are the syntax.