copy multiple fields on selection of dropdownlist

[KimDS]

I am making a DB to register working times and places of staff.
I have some tables of which staff details and worktime registry are relevant for my question.

In a form I fill in the working time, place, date and person. I select the name of the person with a dropdownlist.
When selecting a person with the dropdownlist I want to copy some fields from the person's record in staff details to the new record I am making in worktime registry.

The reson behind this is that some fields in the table staff details may change over time and in my table work time registy I need to save soms fields as they were at that time.

What's the best way to accomplish this in MS access? Do I need to code?

Thank you for helping me out!

 

[John Big Booty]

Welcome to the Forum

Drop Down lists or Combo Boxes by their very nature allow only one item to be selected from the list.

What you will need is a Multi Select Listbox.

 

[KimDS]

Thank you!

However I don't think that is what I am looking for.
I will only select 1 person in the dropdownlist. The dropdownlist will add this persons ID to the new record in the worktime registry table. Besides this persons ID, I also want to copy a few other fields from this persons record in the staff table to the new record in the worktime registry table.

 

[John Big Booty]

Sorry my bad I misunderstood your initial question

How are you creating your new records?

In any case you only need store the persons ID. Storing anything more would be in breach of the rules Data Normalisation.

 

[Tallbloke]

I think you can do this using hidden colums in the drop down.

As well as just the name have the other information you need in the columns.

Then, after update of the dropdown use something like :

Me.HotelName = Me.HotelCombo.Column(0)