docmd.findrecord

[seeker]

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.

 

[Allen Browne]

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