docmd.findrecord

S

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.
 
A

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
 
Top