Cant filter Combobox

[maax555]

Hi I have what I feel is a very simple task and that is to filter the SimilarTo ComboBox so that it only shows data related to the Customer ComboBox.


I tried adding to criteria FORM![frmPartNumber]![PartNumber] and variations of this but not success.
Any help or link to a similar filter so I can work out how it is done would be appreciated.Database13 (1).accdb

[Welshgasman]

It is called cascading combos

I would not use Table Lookups either.

Plus I see you have already asked this previously?
https://www.accessforums.net/showthread.php?t=89348

[maax555]

Hi, yes I did think I had asked this or very similar, however when I searched for my user name I didn't get a single hit. I assumed I had used a different site or username.
Thanks for your reply.

[Welshgasman]

Click on your username, the View Forum Posts is another way.