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!