Required help on Lookup fields

HI all,

I am looking for some help on a lookup field. Basically I have a field on a form that is referencing another field, which is all good and it pulls the data through. The only thing is that it does not update the table that the form is built from and I am not sure how to go about having it do this.

So field is this [Employee No].[Column](1). I thought I could do setvalue when I hit save record button, but it just comes up with automation error.

Any help would be appreciated as I have a few fields that have simple lookups in them, which do not store to the table.

Thanks

Required help on Lookup fields