When I select a value from the Section field, it should automatically combine with the corresponding values. (1 Viewer)

[moin555]

When I select a value from the Section field, it should automatically combine with the corresponding values from other columns (taxpayernature, taxpaymnetsection, code) and display as one string. I need code converts numbers into words. I downloaded it from the internet, but it's not running

 

[MadPiet]

for example?

 

[Gasman]

You just concatenate the column values in the AfterUpdate event of the combo.

 

[CJ_London]

Suggest show the code you downloaded

 

[mike60smart]

When I select a value from the Section field, it should automatically combine with the corresponding values from other columns (taxpayernature, taxpaymnetsection, code) and display as one string. I need code converts numbers into words. I downloaded it from the internet, but it's not running
View attachment 119813

You have a table named "nn" with no PK but lists all of the values you need to concatenate.

Which Form has the Combobox where you want to select a "Section" ??

 

[Pat Hartman]

You need to provide some context. If the problem is that you only see the first column when you select an item and you want to be able to see all three, then the solution is to modify the RowSource of the combo to be a query that selects the four fields and concatenates three of them.

Select ThePK, Column1 & " " & Column2 & " " & Column3 as ConcatValue
From YourTable
Order by Column1 & " " & Column2 & " " & Column3

The bound column remains ThePK which is always hidden in this situation so the ColumnWidths property should be:
0, 3"

Or Make the 3" longer or shorter as desired so that in most cases 100% of the concatenated value is visible.

 

[moin555]

for example?

when i click section head all deatil add in section field

 

[Gasman]

when i click section head all deatil add in section field

See post #6

 

[arnelgp]

see if this is what you need.

 

[moin555]

see if this is what you need.

yes sir when i click section from selection . show in this sequence ,101A/1, Withheld Income Tax (Final),Payable u/s 101A @ 10%,64010041 all code are showing combine

 

[arnelgp]

here again

 

[moin555]

here again

sir it is same file check again

 

[Gasman]

Are we asking for Section Description to hold those values in that order?

 

[moin555]

Are we asking for Section Description to hold those values in that order?

yes sir

 

[arnelgp]

sir it is same file check again

did you run it?

 

[moin555]

did you run it?
View attachment 119823

yes sir

 

[moin555]

yes sir

 

[arnelgp]

obviously, the VBA is not running, because there is a code in the Form's Current.
you must Enable the macro (if there is a Yellow warning) to your db.
or before opening the db, right-click on it and on it's Property->Unblock it.

 

[moin555]

 

[Gasman]

You need to unblock the file.