Displaying selected fields in a List based on a combobox issue (1 Viewer)

[bmaccess]

Hi there.

This is my form details.

I need to show only the Names of learners selected from a specific based on the selection in the combobox named cmbGradeSelect.

But when I run it I get a blank List

When I hardcode it with “1A” I get the correct result. I think I have some reference issue to the combobox.

Anybody can see what code I must change please.

Thanks

Listbox

 

[The_Doc_Man]

Which column counts as the bound column of the combo box? Because that is the value returned for a combo from which a selection was made. Note also that the combo box columns are zero-based, i.e. start numbering from zero.

 

[cheekybuddha]

Underneath the existing criteria, in the 'or:' line, try putting:
[Forms]![frmLearnerBaseDetails]![cmbGradeSelect] IS NULL

 

[pbaldy]

You haven't shown your code, but make sure you are requerying the listbox in the after update event of the combo box.

 

[bmaccess]

Underneath the existing criteria, in the 'or:' line, try putting:
[Forms]![frmLearnerBaseDetails]![cmbGradeSelect] IS NULL

Hi there. Thanks for the suggestion of the IS Null. It does bring up the records in the List box but my actual fault was that I did not requery my List Box in the After Event of my combobox selection.

 

[bmaccess]

You haven't shown your code, but make sure you are requerying the listbox in the after update event of the combo box.

Hi there. Thanks for your suggestion.You were spot on with the requery of the listbox in the after update event. I was about to give up and try the requery and it works. At first I was not sure where to requery. But after a few tries. I realise I must List45.requery in the after update in the combobox and it works brilliantly. Thanks once again .

 

[pbaldy]

Hi there. Thanks for your suggestion.You were spot on with the requery of the listbox in the after update event. I was about to give up and try the requery and it works. At first I was not sure where to requery. But after a few tries. I realise I must List45.requery in the after update in the combobox and it works brilliantly. Thanks once again .

Happy to help!