CurrentRecord Property Syntax

[P5C768]

I'm trying to get a field to calculate based on other fields in a record.

For example:
if cboCName1 = "a" then
txtamt1 = 0.15 * txtpol1
endif

This code seems to work but it always calculates bases on the first record in the database rather than the current record. How can I get it to update based on the active record, and for that record only (i.e. not override every record with the current one)?

Thanks!

[pbaldy]

Well,

Me.cboCName1

would refer to the current record. Where exactly do you have that code? Also, make sure your control is bound. If it isn't, the same value will appear in all records in continuous or datasheet view.

[P5C768]

Thanks Paul. I failed to mention in my quick example that I actually used ms.cbocname1. But your other comment seemed to fix my problem. I had started a new module to store the code in, rather than on the module for the form I was refrencing.

Is there any way to reference the current record on a form but store the code in a seperate module? I only ask because I have a large amount of code and I need to repeat it 5 times. If there is not, it seems to work just fine when stored in the form module. Thanks!

[pbaldy]

Well, from outside the form module

Forms!FormName.cbocname1

would refer to whatever record had focus. What are you trying to achieve?

[P5C768]

Calculate a commission based on information entered in a tab control on a user form. The tab control has 5 tabs, so 5 possible commisions for each record. The calculation of the commision is based on 8 different criteria, also stored in the tab control.

[pbaldy]

Well, you can put a function in a module and call it as appropriate. The "Forms!" syntax will refer to the record with focus. I'd be more likely to make it a function in the form's module, presuming it will only be called from that form (and since you want to refer to that form, I assume that's the case).

[P5C768]

That is the case, so I will give that a try. Thanks!

Galt/Taggart 2012?

[pbaldy]

No problemo.

They'd get my vote!