Data Access Page, Querie Problem

[Paulsly]

Hi there
I created a data access page in MS Access 2000 pro.
The page consists of a combo box that looks up a customer list and inserts the customer infomation into the field text boxes below.
When using my table it works fine, but as soon as I use a querie no customer names appear in the combo box.
The funny thing is that if there is no critria specified in the queries it works fine, but as soon as I add critria to sort out customers from A-C / D-L and M-Z (These are 3 queries for the same page) it do's not appear. Is there away to get around this or fix the problem.
Thanks.
Looking forward to hearing from you
Regards Paul

 

[Paulsly]

Hi all
I worked my own problem out Data Access Pages dont use the same wild cards as normal Access forms. They use ASCI 2 wild cards so in my querie I was using "like(*)" to sort out the Alphbetical order of my customer list and Data Access pages do's not recanise that character. Instead I should have used a (%) sign, Whick I did and it worked perfectly.
Hope this info could help some of you.
Cheers