Copy the value of a particular column of a combobox

[MF_PA]

good morning
in my database I have a form and a report (both read a query).
Into the form I have a combobox with 5 columns, which displays the first column but uses the value of the second. This second value (numeric type) is used to filter the mask.
example data of the combobox:
Name; num;city;zipcode;nation
Anthony; 1;Rome;00100;Italy
Mary;2;Turin;10100;Italy
So if I choose the Antony item the value of the combobox displays Antony and my filter query gets the value 1.
Instead, I need to use into my report a label control where to display the value of the first column of the combobox present in the form, therefore it must display Antony.
example:
mask name = mAA
Report name = RptAA
mask combobox name mAA = cmbx1
mask label name mAA = Lblcmbx1
report label name RptAA = Lbl1
Here are my instructions that currently return 1 and not Antony
mAA)

Private Sub cmbx1 _AfterUpdate()
me. Lblcmbx1 .caption =  me. cmbx1 Column(1, Me.cmbx1.Items)  
end sub

(RptAA)

Private Sub Form_load()
me. Lbl1.caption = Forms!mAA! Lblcmbx1 .caption
end sub

thank you for the clarification

[Micron]

combo and list box column is zero based, so second column is 1. Perhaps that is your issue.
Usually, first column is the autonumber id of a record - not the second column. I don't know if your 1 and 2 values are record id's or not, but your setup looks a bit unusual.

EDIT - what you show will work in code but not in a query. It's a bit more difficult to use the column value in a query. Then again, you shouldn't have to if this was the other way around.

[mike60smart]

Hi

Name should not be used as a fieldname as it is a reserved word in Access.
I would suggest you rename the field to "Firstname"

The normal configuration of a Combobox is as follows:

Auronumber:FirstName: city: zipcode: nation
1 Anthony;Rome;00100;Italy

When you make the selection of Anthony on the Form then the Autonumber is stored.

In the Report which is based on a Query you would add the value of Firstname from the table that contains the Firstname field.

[MF_PA]

Solved!

I've forgot that the combo column and the list box column are zero-based.

here is my code

 Dim MyCbox As Integer: MyCbox = Me.Cmbx1.Value

Me.Lblcmbx1.Caption = Me.Cmbx1.Column(0, Me.Cmbx1.Value = MyCbox)

Thanks for the two clarifications

[MF_PA]

thanks , but it was only an example and the real fieldname was another one .

[Micron]

I don't see why you need to specify the row option?

[CarlettoFed]

Maybe it's best if you delve deeper into how to use a combo box.
https://learn.microsoft.com/en-us/office/vba/api/access.combobox

[Micron]

I presume white icon in post 5 image is the "New" button, which was clicked then the db window opened? I suspect that button would not move the window, just open it?