Hi Orange, After trialling a few designs, I realised the design I was trying to accomplish was 'Tabular'. This set the data out like I was after. I'm sorry as I probably didn't explain it very well.
Hi Ranman256, I was able to get your VBA code working. Thank you. The only question is about searching to 'Name' or 'Company' and to display all applicable results. I'll need a line like:
Code:
Me.Filter = "[Company] like '*" & Me.txtbox & "*'"
as well as
Code:
Me.Filter = "[Name] like '*" & Me.txtbox & "*'"
Not sure though how to do this as If, If, and Else Statement. I'm sorry as my knowledge is very basic.
Thank you for your help. Paddington