Ok ive got a criteria on a surname which is based on the value from an unbound text box.
Currently in the query the criteria is:
Like "[forms]![frmalpha]![letter].[text]*"
Which would return all fields starting with the value of letter.
This returns nothing. If I close the form the query doent prompt for the value.
If I just put [forms]![frmalpha]![letter].[text] then it will return records, and if i put a* it will return records, but combining the two doesnt work!
Any help would be most welcome, is it a syntax error.
Thanks
Ian.
Currently in the query the criteria is:
Like "[forms]![frmalpha]![letter].[text]*"
Which would return all fields starting with the value of letter.
This returns nothing. If I close the form the query doent prompt for the value.
If I just put [forms]![frmalpha]![letter].[text] then it will return records, and if i put a* it will return records, but combining the two doesnt work!
Any help would be most welcome, is it a syntax error.
Thanks
Ian.