Hi
I'm not really a beginner but not an expert either, I am having a problem with displaying only certain records in a combo box in a form that relates to an a record on another form
I am trying to:
wanting a form for ordering parts from a supplier, I Have a main form with a drop down combo box of the list of suppliers when a supplier is selected it will populate a subform with orders for that supplier, (got that bit worked out fine) there is another subform that selects items to be ordered from a parts list by selecting parts from a combo box which uses PartID Description Cost supplier as its row source from the Parts table. I want to only allow parts from the selected supplier on the Order subform to be displayed for selection. I've tried building an expression but it doesn't work I would like to uses a filter but can't seem to get my mind around the filtering method. Or is there any code I can use
Hoping there is an answer the Parts table contains in excess of 100,000 records