SQL Question

[NoellaG]

Hi,



Noella, Where would I enter this to achieve my result?

Thanks guys for your time!

You can do this in the query design view or in the SQL view, where it would be something like:

 SELECT tsysDual.dualTextFROM tsysDual
WHERE (((tsysDual.dualText)=[Forms]![frmCustomer]![fsfrProductsCust].[Form]![txtID]));

Of course you need to replace the dummy names with the correct names from your DB

[dannybeaver]

pbaldy,

I do not know how to thank you!!!

The double click event is finally working thanks to you!

Thank you so much for all of your help with this, you have solved a struggle I have had for quite some time now.

Best regards,

D

[pbaldy]

Happy to help, and welcome to the site by the way!