sambucaman
Registered User.
- Local time
- Yesterday, 20:24
- Joined
- May 6, 2010
- Messages
- 41
I have a form built from a search query, using Like "*" & [Search by Name] & "*"
with the results being listed in as a form (in datasheet view)
example, a search for Smith, would yield a results list similar to;
AM12456, steve smith, 1 high st, london
TD23646, helen smithson, 33 the street, birmingham
AM15545, bob shoesmith, 181 west road, glasgow
etc (where the first column is my reference and primary key)
Is there a way I can create a hyperlink in each of the results, so that I can click the reference to open my main customer form?
Appreciate any help or ideas.
Thanks
with the results being listed in as a form (in datasheet view)
example, a search for Smith, would yield a results list similar to;
AM12456, steve smith, 1 high st, london
TD23646, helen smithson, 33 the street, birmingham
AM15545, bob shoesmith, 181 west road, glasgow
etc (where the first column is my reference and primary key)
Is there a way I can create a hyperlink in each of the results, so that I can click the reference to open my main customer form?
Appreciate any help or ideas.
Thanks