Setting a Default Value when RowSource is a Query

[P5C768]

Not sure if this should go in forms or queries...

I have a list box that populates from a query after another field is updated. It appears that using the defualt value property and/or using an if statement to set the field does not work because it is based on a query. Is there a way to get around this?

I would just like the field to display N/A if there are no results from the query.

[ajetrumpet]

So if there are no entries in the box after it is requeried, you want to show "N/A"?? I've never used a default value with a list box, but if there is one, you'll still have the box being displayed. I wonder if having a hidden textbox on the form would work better? Say, if the listcount of the box is 0, display the textbox, if not, hide the text and display the list.

That may get you started. There are plenty of ideas that can spawn from that one.