docmd.findrecord

How can I limit the docmd.findrecord to one column in the datasheet subform?
It finds anything that starts with c for example whether that c is in the
name column or address column. Thank you.

Use FindFirst on the RecordsetClone of the form instead.

Here's an example of using FindFirst to search a specific column. The
example uses an unbound combo, but you can do the same thing with an unbound
text box:
http://allenbrowne.com/ser-03.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"seeker" wrote in message
...
How can I limit the docmd.findrecord to one column in the datasheet
subform?
It finds anything that starts with c for example whether that c is in the
name column or address column. Thank you.