copy from another table "button"

[doran_doran]

I have a form tie to a table called "tbl_groups". I have a basic case table.

The form "frmGroups", I have few fields that are same in tblBasicCase. I would like to put a button on the frm "cmdBasicCaseCopy", which will copy 5 fields from table "tblbasiccase" to this form or to "tbl_groups".

I tried this but not working (and it's only for one field, i need it for 5 fields)
Me.cboBillingStructureImport = [tables]![tblplanmatrix]![BillingStructure] where me.GA_Number = [tables]![tblplanmatrix]![ga_number] and me.PlanNum = [tables]![tblplanmatrix]![plannum];


table "tbl_groups" and "tblBasicCase" are relationshiped by ga_number and PlanNum.

Regards / Dianna

 

[doran_doran]

I took care of this one. Thanks anyway...

I made identical field with different name and did a dlookup.

and on the click button i used

me.field1 = me.dlookupfield1


It works. I know this is unprofessional way of doing it. but i have the project due today.

Thanks everyone / Dianna.

PS: I like the new site and lot faster.