Vehicle Maintenance - Vehicle name to Licence Plate

[kellee]

Hi,
I am using the pre-made Vehicle Maintenance Form on Access 2016 and need to change the Vehicle drop down from (year, make, model) to the Licence Plate as we have so many vehicles that are the same.


Does anyone have any suggestions?

[Bob Fitz]

You'll need to change the Row Source property of the combo box which is usually a SELECT statement.
If you post what you already have it will make it much easier to help

[orange]

kellee,

I agree with Bob --it will help you and readers if you post a copy of your database in zip format.
I would suggest you do not use names with embedded spaces for fields or objects. It will lead to syntax errors.
Good luck and welcome to the forum.

[kellee]

Thanks Bob, If I was to start from scratch with the pre-made template how would I do this?

[Bob Fitz]

Thanks Bob, If I was to start from scratch with the pre-made template how would I do this?

Start what from scratch?
How would you do what?

[Micron]

Find query "Vehicles Extended". Open in design view (you may have to drag the design grid portion up from the bottom to make it visible). Expand the left most field. You will see this expression

Vehicle Name: [Year] & " " & [Make] & " " & [Model]

You would need to change this 'calculated' (concatenated) field in the query itself. Another possibly more sensible approach would be to hide the existing control (in case you need it back later) and add one for the license number as there isn't one on the form. You would have to modify the query behind the form (Past Expenses) to include the license field.

As for the spaces in names, what else do you expect from a Microsoft template except things that violate good design principles?