Show all record in combobox (1 Viewer)

[theinviter]

Hi Guys
need help
i have 2 combo box, if combo 1 updated will automatically filter combo2, but wanna if combo 1 is null then show all record in combo2.
i tried this code in query but not showing all record.

Nz([Forms]![Master_List]![Combo46],"*")

so what to do.

 

[arnelgp]

Use this on ur filter:

[Fieldname] like Forms]![Master_List]![Combo46] & "*"

 

[theinviter]

Use this on ur filter:

[Fieldname] like Forms]![Master_List]![Combo46] & "*"

i tried on query but does not work.

 

[arnelgp]

you may also try:

IIF(IsNull([Forms]![Master_List]![Combo46]), [FieldName], [Forms]![Master_List]![Combo46])

 

[theinviter]

you may also try:

IIF(IsNull([Forms]![Master_List]![Combo46]), [FieldName], [Forms]![Master_List]![Combo46])

what to write in FieldName],

 

[arnelgp]

Same field as you are trying to filter.