parameter postcode

[T3E]

hi, erm i was wondering if some one can give me the criteria for the following:
basically i have a form with a field called postcode and when i enter a part
of the postcode i want the query to display all properties with the full
postcode? e.g i enter e7 i want the query to display all properties that are
e7 5dl, e7 6hf, e7 3ed etc.
so when half a postcode is entered i want full postcode to be included in
the search?

thank you.

 

[KARL DEWEY]

Use this as criteria --
Like [Enter first part of PostCode] & "*"

 

[T3E]

Use this as criteria --
Like [Enter first part of PostCode] & "*"
--
KARL DEWEY
Build a little - Test a little

hi, erm i was wondering if some one can give me the criteria for the following:
basically i have a form with a field called postcode and when i enter a part
of the postcode i want the query to display all properties with the full
postcode? e.g i enter e7 i want the query to display all properties that are
e7 5dl, e7 6hf, e7 3ed etc.
so when half a postcode is entered i want full postcode to be included in
the search?

thank you.

but the psotcode field is in a form so when i enter a postcode in the form
thats when the query runs.