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.
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.
