Field name copy

[Xenix]

Hello is there a way to copy the current record field name into a table field that is not open?
If I use [Quotation].[authorise] = Me.authorise I can't get it to work?

Thank you
Mike

 

[Fizzio]

Mike, do you want the field name or value copied?

 

[Xenix]

sorry just the value contained within the varible or field name called "authorise"
it's just a persons name stored in one table and I want it to copy to another table as I select it

 

[Fizzio]

is your form based on a query? If so, add the field you want to copy the info to and code it
Me.Fieldname1 = Me.Fieldname2

It has just struck me though why you are duplicating info in tables?