Updating a field of an Access table with data from form -

i working on access 2007. have table fields in it. had created form table , 1 of fields of table concatenation of 2 fields same table.

there 2 fields oppno , material in table. had created form these (and others in table) fields. there field oppmat blank in table. however, had got data oppmat field populated concatenation of oppno , material fields in form. looking @ having table updated data of oppmat form same corresponding field in table.

kindly advise how achieve this.

thanks , regards,

this might possible if these cases met:

• the field oppmat has same structure , can assure does.
• users not able or unlikely deviate structure.

notably should use left(), right(), mid() , on. whatever works best structure. can use string modifiers: https://msdn.microsoft.com/en-us/library/dd789093.aspx

on other hand must admit sceptical if solutions best. here my reasons:

• users unpredictable , continously deviate intended way use application.
• using string functions , fixating on 1 structure makes code construction inflexible, hard maintain if changes occur , prone errors.
• the alternatives seem better little drawback.

my suggestions alternatives:

• use 1 textbox each field have 2 textboxes. can position them way looks continous text. not otherwise user beconfused.
• you can add label shows concatenated fields. input use 2 different textboxes.

cheers!