Auto-Populate Combo box

[vincenoir]

Hi Everyone

My first post, I'm quite new to access, particularly using VBA and SQL in access, I've searched all over the net for a solution to this problem and hope someone can help. It's probably really simple, but like I said, I'm new

I have a form with a combo box that populates it's values using a SQL query. This query takes it's one of it's properties from the form (cboCombo1):

SELECT tblTable1.PageName


FROM tblTable1
WHERE tblTable1.field1=Forms!frmForm1![cboCombo1]
AND tblTable1.Field2=0;

My problem is that I need the combo box to populate the values each time you try use it, as cboCombo1 changes depending on what record you are viewing/editing.

Hope this is clear!

Thanks in advance.

[RuralGuy]

Requery the ComboBox in the GotFocus or OnEnter event of the ComboBox.
Me.ComboBoxName.Requery
...using your ComboBoxName of course.

[vincenoir]

Thanks very much. Worked perfectly.

[RuralGuy]

Glad I could help.