Form List Box no longer populating

[dmelsass]

Very fustrating.

I had at one point the list box working fine off a query that referred to one table. However since that one tabled query had 3 related fields that only stored the Auto number and I wanted it to display the events name and not the event's Auto ID #, I changed to a query that references 3 tables at once to pull that data in then set it to filter the duplicates by having it only display unique data.

Everything in the query runs as expected and contains all the fields I want and records. I have also two criterias for the query one for the date and another for a specific group each person in the data is assigned to. Again the query works as intended.

Howeverthe listbox won't populate.



I had created a combo box switch that controlled group criteria in the query and requeried the list box via onchange event. That setup worked fine for the 1 table query setup fine, but the 3 table query setup the query works fine but the list box does not.

Any help in this field would be great. I can post screenshots and explain further if needed.

Sent from my SM-G935V using Tapatalk

[dmelsass]

Very fustrating.

I had at one point the list box working fine off a query that referred to one table. However since that one tabled query had 3 related fields that only stored the Auto number and I wanted it to display the events name and not the event's Auto ID #, I changed to a query that references 3 tables at once to pull that data in then set it to filter the duplicates by having it only display unique data.

Everything in the query runs as expected and contains all the fields I want and records. I have also two criterias for the query one for the date and another for a specific group each person in the data is assigned to. Again the query works as intended.

Howeverthe listbox won't populate.

I had created a combo box switch that controlled group criteria in the query and requeried the list box via onchange event. That setup worked fine for the 1 table query setup fine, but the 3 table query setup the query works fine but the list box does not.

Any help in this field would be great. I can post screenshots and explain further if needed.

Sent from my SM-G935V using Tapatalk

First one is design view and highlighted on selector combo box that used to control list box.

Second is form view showing it not working as it used to.

3rd is the 3 table query working as intended

Sent from my SM-G935V using Tapatalk

[June7]

Post the properties of combobox and listbox:
RowSource (the SQL statement if references a query object)
BoundColumn
ColumnCount
ColumnWidths

Why combobox OnChange event instead of AfterUpdate?