Showing VBA variables on the form

[gpeirce]

I'm an experienced SQL programmer but only a beginner in Access.



I posted before but things got too confusing. I have some variables coded in a VBA module. The results are in fields called intA, intB and intC.

I also have 3 texts boxes on a form. How do I code the text boxes so I can display intA, intB and intC? Do I put something in the control source? Do I name the box in a certain way? Do I put some code in like me.intA.value = something or other??

An accdb example would be nice too, if you have it.

Thank you so much for your time.

[June7]

I am confused. The fields are intA, intB, intC or are these the VBA variables?

VBA to set values of textboxes from variables would be like:

Me.textboxname = variablename


What do you mean by an 'accdb example' - an accdb is Access database file extension.

[orange]

gpeirce,

I realize you are new to Access and related forums. However, in any forum, when you cross post - that is post the same question on multiple forums, it is considered proper etiquette/netiquette to inform readers that you have done so. It isn't wrong to cross post, but it is "poor behavior" to not tell readers you have done so.

Here is why.

[gpeirce]

Exactly what I needed! Thank you.

[gpeirce]

Thank you, orange. I sure did not know that. Will do next time.