Combo Box problem

[mcktigger]

Hi

I'm working on a db for recording job cards for fleet vehicle repairs. I have a form for creating new job cards with a combo box showing vehicle reg nos. This is based on a query which checks the customer id so only the vehicles for that customer are displayed. To allow for private reg no the vehicles table has fleet id (autonumber) fleet no & reg no.

The job cards table stores the fleet no not the Reg No since the vehicle could have a reg no change many times in its life. This all works fine until it comes to editing existing job cards. I have one form for new job cards (works fine) and another for editing existing jobs.

When the user goes to edit a job card I want to be able to display the Reg No of the vehicle entered when the new job card was created. In case the user made a mistake with the Reg No I want to also display in the same Combobox all other Reg No available for that particular customer.

Is there a way to base the combobox on a parameter query but default to the data for a particular recordsource?

I hope this makes sense and sorry for the long winded explanation.

Thanks