Record Selecting

[Guest]

I have a continuous subform that I have filtered by a combo box. When I make
a selection from my combo box the record selector goes to that specific
record. If I wanted to use that specific record in a calculation on my form,
how would I go about this? I have an unbound control on my form that I want
to use but I only want it to use the record that I selected.

 

[Albert D.Kallal]

On the main form, you can use any value from the current record in the
sub-form like

me.MySubFormControl.form!NameOfField

 

[Guest]

Try

In the textBox write
=[SubFormControlName].Form![FieldName] +
[SubFormControlName].Form![Field2Name]

Or

On the OnCurrent event of the subform write
Forms![MainFormName]![TextFieldName] = Me.[Field1] + Me.[Field2]

 

[Guest]

That worked perfectly. I didn't realize I could do a simple calculation and
it would automatically use the field that was selected. Thanks for your help!

Try

In the textBox write
=[SubFormControlName].Form![FieldName] +
[SubFormControlName].Form![Field2Name]

Or

On the OnCurrent event of the subform write
Forms![MainFormName]![TextFieldName] = Me.[Field1] + Me.[Field2]

--
\\// Live Long and Prosper \\//
BS"D

I have a continuous subform that I have filtered by a combo box. When I make
a selection from my combo box the record selector goes to that specific
record. If I wanted to use that specific record in a calculation on my form,
how would I go about this? I have an unbound control on my form that I want
to use but I only want it to use the record that I selected.