Query data from bound form

[tfaiers]

I'm trying to create an update query based on an open bound form.

During testing I'm getting a strange result where in a select query (for viewing purposes) I've got Expr1: and Expr2: which reference fields on the form like so:

Expr1: [Forms]![Module Program]![postcode]

Expr2: [Forms]![Module Program]![TOCES Ref No]

The really strange thing to my mind is that the postcode reference (which is text) shows up the postcode in the query view as it should, but the [TOCES Ref No] (which is a number field) shows up as - ''

Any thoughts on that?

Many thanks
Tony