Using a filtered combobox in a form to recall a record

[maax555]

Hi, looking for a way to recall a record for editing by using a filtered combobox.
I have had this working without a filter on the unbound Combo26.
However when I choose customer to filter down the results in the unbound combobox, the filter works but the record remains on record 1 instead of going to the record of the part number I enter in the Combobox.
what am I doing wrong?



thanks.

[jojowhite]

see the AfterUpdate event (VBA) of Combo26.

[maax555]

Hi Jojo, many thanks. but this is not working for me.
When I choose the customer I should get a list of all customers, currently 1 to 5.
If I choose customer 1, currently PartNumbers 1234/1 and 2345/1 will be displayed in PartNumberSearch combobox.
If I choose customer 2, then 3456/1 and 4567/1 will be displayed Using a filter in the unbound combobox.
Currently records are in order of partnumber, so record 1 begins with 1, record 2 is 2 (2345/1) etc.

So if I choose customer 2 this will (after filtering in combobox) show partnumbers 3456/1 and 4567/1, (record 3 and record 4)
When I choose for example 4567/1 I need record 4 to be active.
I will then be entering additional data (fields not added to form yet) and this will be stored to the record.

So my uploaded form works apart from its not pulling in the record associated with the part number I enter.

[jojowhite]

here try this again.

[maax555]

here try this again.

Brilliant. I see you did the form from scratch and used combo wizard box for all the fields?
I thought I only needed to do that for the field I was using to search for the part number.
I just looked at the code entered for each field event :-(
I like to obviously see what has been used and try to understand, but that looks more complex the the codes I usually get to use.

Many thanks for your help. Really appreciated.