After a year, I'm still confused.
I got a suggestion from a computer magazine here in the UK. They suggested a button on the Contact Details form linked to the following code:
Private Sub Command282_Click()
txtselect -"[Last Name] - '" & Me.[Last Name] & "' AND [First Name] - '" & Me.[First...
Thanks for the replies Mr B and prley.
Mr B - I thought the filter was in the VBA where it says
str = "CustomerID = '" & Me!CustomerID & "'"
Please let me know if this is wrong.
prley - The fact is I'm not sure how to post the query ! There doesn't seem to be a separate file I can attach ?
Thanks for this. In fact the record source IS a query so no cigar I'm afraid.
I'm probably just doing something really stupid with the syntax.
Regards
Colin
Hi. I am a novice and would appreciate a helpimg hand.
I have customised the contacts database and now want the ability to print a single label using a button on the contact details form.
Having searched the web, I found a very helpful article by Susan Harkins which explained precisely how to...