Querying in Access Page

[Guest]

I am trying to use an Access Page to query a list of Subdivisions. But I try
to use a query that I have to input part of the subdivision name and it won't
find a single record. I am using Like "*" & [Enter a character(s) in
Subdivision name: ] & "*" for my query....is there a reason that the
records do not appear? If I run the query alone it works fine, but it
doesn;'t work within a data access page. Any help would be great!

 

[Ken Snell \(MVP\)]

Data Access Pages uses ADO recordsets, not DAO recordsets. As such, you must
the % as the wildcard character, not *.