How Can I get 2 fields selected on a list

[TL_Reed]

So I have a list on my form that has data and the date the data was created (i.e. 12345, 2/1/2020). I want to select the date field and save it in a form field but I also want the data field saved at the same time.
As an example when I click on 2/1/2020 I want it saved into a form field called Selected Date and then I want the data saved to saved data field on the same form.
When I create the form list it allows me to select what data I want to save to a field but does not allow me to save the other.

Hope this is clear. Thanks

 

[theDBguy]

Hi. Check out the Column() property.

Sent from phone...

 

[The_Doc_Man]

theDBguy is limited by phone response, so I'll step in.

If you have a combo box, it can have multiple columns selected based on the fields in the underlying query. And there usually IS such a query because if you built the combo with a form-based wizard, it likes to build queries for that situation. If you did that, you had the option to include more than a key field and a data field with the combo - you could include multiple fields.

When you select a row (record) in the combo, the whole row is selected. Here is a link to the documentation for combo boxes. What you want to look at are two specific properties - .ListIndex and .Column(col,row)

ComboBox object (Access)

Office VBA reference topic

docs.microsoft.com

ComboBox.Column property (Access)

Office VBA reference topic

docs.microsoft.com

ComboBox.ListIndex property (Access)

Office VBA reference topic

docs.microsoft.com

So ... if you want to get more than one element from the selected row, use the .Column property to pick the specific column, perhaps assisted by the .ListIndex property to identify the selected row.