Hi there, seriously I need help with a table and form. In short I want to know if I can modify a query to return all duplicates but only if it matches a combo box entry if so can I then have the query add the matching data to the same table?
I have a table of customer names and a macro to run a query to find duplicate names from my table after update. I just don't want to keep typing all the details when they are already there basically. So say Mike called and on my form I typed mike into the combo box instead of all the duplicates appear Can I modify it to show only customers called mike?
PHEW!
Oh btw I don't now anything about sql or vba and would be really appreciative of any help given.
Thanks in advance (Fingers crossed)
I have a table of customer names and a macro to run a query to find duplicate names from my table after update. I just don't want to keep typing all the details when they are already there basically. So say Mike called and on my form I typed mike into the combo box instead of all the duplicates appear Can I modify it to show only customers called mike?
PHEW!
Oh btw I don't now anything about sql or vba and would be really appreciative of any help given.
Thanks in advance (Fingers crossed)