In my database (attached), I have a form ('Households & Sims') with a combobox record selector to select a household. It works well until I try to add a criteria to the query.
If I add [Households].HouseholdExists=True to the form's Filter or 'WHERE (((Households.HouseholdExists)=True))' to the form's query, the associated records are visible in HouseholdPicker but nothing happens when I select them.
However, if I also add 'WHERE (((Households.HouseholdExists)=True))' as a criteria the HouseholdPicker query, this results in a glitchy behaviour similar where the combobox goes blank after selecting a record. I tried putting
into the Form's On Current but that didn't help.
Any suggestions on what to do? Thanks in advance.
If I add [Households].HouseholdExists=True to the form's Filter or 'WHERE (((Households.HouseholdExists)=True))' to the form's query, the associated records are visible in HouseholdPicker but nothing happens when I select them.
However, if I also add 'WHERE (((Households.HouseholdExists)=True))' as a criteria the HouseholdPicker query, this results in a glitchy behaviour similar where the combobox goes blank after selecting a record. I tried putting
Code:
Private Sub Form_Current()
Me.HouseholdPicker = Me.Recordset![Households.HouseholdName]
End Sub
into the Form's On Current but that didn't help.
Any suggestions on what to do? Thanks in advance.