#Name? in Form

[forms_are_nightmares]

All,

I have to imagine this can be done but I can't figure it out. Hopefully, someone in here can help me.

I have a crosstob query with that returns 4 values: North, South, East, West. The query counts the number for each location, e.g., 4 in the South, 3 in the east...etc.

This query is the source for a subform on another form. When each of the North, South...etc., have values in them, everything is fine. But there are times when there could be 0 locations in the east. When this happens, the subform returns a #Name? error, which makes sense.

How can I either show a 0 or a blank?

Any help/suggestions are appreciated.

 

[DCrake]

In the column headings property in the cross tab query enter the column headings; North, South, East, West. This will force the column headings to appear even if no data is present and as such genrate the fileld names for the sub form.

 

[forms_are_nightmares]

Thank you so much- worked like a charm.

I appreciate your help and very quick response.

 

[DCrake]

Somethingto remembr for the future. Glad you ar sorted