Hi all,

I have an advance version of a user form.

Basically I am wondering if the user can use 2 boxes to search and populate the record.

Ie./ Box 1= Vehicle Registration Box 2= Date

This sheet will be used throughout each month and each vehicle registration may have more than one record that month

So I need the user to be able to input the vehicle reg and for the form to populate the relevant record.

Anyone have any ideas ?

I current have a Unique reference which is a combo box that once you select it auto populate the record but this will take forever having to populate ach record to find which one the user is looking for.