Access combo box help

[Arsey]

I have made a form in Microsoft Access and I want to make it so there is a combo box, I select a BookingID (primary key) from the list and it automatically updates the rest of the fields based on the BookingID used.

I can make the combo box but every time I select a certain ID from the drop down box, it just changes that field and not the rest of the form (date, car registration etc)

Could somebody enlighten me on how to make it automatically update the fields?
Thanks.

 

[Arsey]

 

[WIBSBOT]

create a query.

in the query the relevant field you will need to make the criteria =Forms![YourForm]![YourcOMBObOX]

Then create all fields on your form based on the query.

(or you could use a sub-form based on the query.)

If you need a better explanation have a look in the Access help at Combo boxes or do a web-search 'Access Combo box filter'