Form calcs

Hi all.

On a form, how do I make a field do a calculation and still be bound to a table?

Thanks in advance,

Andy.

undefinedHi Andy..Do you want to transfer the result of the calculation to the table?

If so ... Does the form have a query or table as its source???

I'm a novice but something which has worked for me is to..

In form design goto the code button section- VisualBasic

and into FORM CURRENT

Private Sub Form_Current()
Me![TableFieldName] = FormFieldName
End Sub

HTH David -Perth (Not Scotland)

Hi Dave.

Thanks very much for the reply. To clarify, the form has a table as its source and, as I seem to be a bigger novice than yourself, where do I enter the VB code?

Cheers

Andy.