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

[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" ??

 

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

 

[arnelgp]

just as I said, closed the db.
then Right-Click on it, choose Property.
then check the Unblock it.