Empty value in VBA despite value in record is set

[cesarone82]

HI, I'm getting a strange behaviour in VBA for the "civi" value, I have various variables set, for example "Località", I can get the value of all of them, but for some reason the civi variable in vba is listed as empty despite it has a value assigned, On the button with the "A" in the project forms I just put some line of code to assign a test variable with civi and Località, by debugging I can see that Località works but civi seems empty.
I cannot understand the reason behind this beahaviour.

[Welshgasman]

Too late a version for me.

[orange]

I suggest you provide more info re the issue and how to repeat it. More specific directions. It also helps with context if you show/describe
A)what you have currently, and also show
B)what you want.

For consideration:

-Always have Option Explicit as second line in every module
-Give meaningful names to your controls
-design some test data
-make use of strategic Debug.Print to check program/logic flow

You may have division by 0 in this expression

 =([pj$]-[tbl_pjentries].[Form]![Text20])/[tbl_pjentries].[Form]![Text11]

I do not see where civi is collected?

[cesarone82]

Hi thanks for the reply,

I have to cut part of the code cause of the reference to the phantom pdf library, what i need is to fill some PDF fields with values from my record. Inside my access file, in the frm_projects (record pjnum 32) I have a button doing this (the button with the A) where i just put in the dblclick an assigment to two test variables, first one is test1=Località which correctly set the localita field to test1 variable.
The second (test2) is testing the field civ, which inside record 32 is value 41A (see tbl_projects pjnum 32) but test2 variable upon assignement is empty string. I cannot figure out why considering that I can successful retrieve località field and all others, but not the civ fiels.

See below test2=civ inside VBA should be 42A when launched from form_projects record with pjnum 32

[Minty]

first one is test1=Località which correctly set the localita field to test1 variable.

No it doesn't.
It sets Test1 to the value of Località

Unless that is a language issue - I appreciate English is probably not your first language?

[CJ_London]

you may be bringing civi through in your recordsource, but you don't have it on the form.

try me!civi

which includes referencing the recordset

[cesarone82]

Sorry I'm Italian but i wrote too quickly . In fact the issue is not with test1 variable which is correctly assigned with the value of localita field.

The issue is with test2 which should be "42A" but is "", Yes I know that there is no civi field in the form, but to me it seems that it is not required to have it in the form, since even if localita is not present in the form it correctly assign test2 with its value.

I also had the same idea, but even if I add civi control in the form the content of test2 is "". Apart this error do you confirm that I don't need a form control with a certain value in the form to retreive the value if this one is present in the table on which the form is based? If not how is possible that i can get the value of localita in vba dblclik event in the project form?

[CJ_London]

if i type in the sub

me.c

civi does not appear in the dropdown


and if I type

me.lo
Località appears in the dropdwon


So somewhere you have associated the field Località to the form - perhaps in a control you subsequently deleted

If I add civi as a control, I see a value


and if I subsequently delete the control - the value remains

SO either add the control, then delete it, or use Me!

[cesarone82]

Thank you, I was a bit confused about the fact that Località was working, I don t remember adding it. Anyway the fact that adding and deleting it makes the thing work is a bit confusing.

if i type in the sub

me.c

civi does not appear in the dropdown


and if I type

me.lo
Località appears in the dropdwon


So somewhere you have associated the field Località to the form - perhaps in a control you subsequently deleted

If I add civi as a control, I see a value


and if I subsequently delete the control - the value remains

SO either add the control, then delete it, or use Me!

[moke123]

Also note that you need to have option explicit declared in ALL your modules.