Search results

That makes sense now. I don't want that. Have removed it from the 2nd combo box code and that still works fine. SELECT DISTINCT accounts.ID, accounts.CustomerName, accounts.PasswordRequirements FROM accounts WHERE (((accounts.TeamName)=[forms]![Checks]![TeamNamecbo])) ORDER BY...

I'm not very good at keeping my sources so I can't remember where I found this piece of code I'm afraid. Whatever it does it works for the CustomerNamecbo.

I have a form with 3 combo boxes (TeamNamecbo, CustomerNamecbo and AccountTypecbo). TeamNamecbo just lists all the teams from Teamtbl CustomerNamecbo is filtered (for want of a better word) to show only the customers that TeamNamecbo supports using the following. SELECT distinct Accounts.ID...

Just had a look at my box properties and seen what the issues was. I was copying a rich text box into a plain text box so it shows the formatting. For a change my code was sound!

I'll have access in about an hour to try it.

Still a beginner so please pardon my ignorance/ineptitude :) I would like to be able to join 2 text boxes and then copy them to clipboard. My initial fumbling has had me to joing the 2 text boxes as a string and then set that string as the value of another hidden text box and then copy that...

Sorry for the late reply. Cheers Pbaldy thats sorted it. Also thanks MarlaC.

Afternoon, I have a form on which I use combo boxes to filter a listbox using the following code. ------------------------------------ Private Sub FilterpartsList() Dim strRS As String ' Filter the list box appropriately based on the combo box selection(s) strRS = "SELECT...