Search results

  1. I

    joining 2 fields on a form and populating into a third

    Thanks isskint, ympa and rain for all the help I had the same name for control and control source changed it and all is wonderful in the land Thanks again from Sunny South Africa
  2. I

    joining 2 fields on a form and populating into a third

    Ooops I just checked one thing Even your sample doesn't save into the table - just displays the correct info I need it to save into the table
  3. I

    joining 2 fields on a form and populating into a third

    Cool - thanks - Please explain 1 thing from your sample db The one field name in the table is: prod Code - yet in the subroutine you specify Prod_Code where is that variaqble (or field name coming from) - I don't see it or maybe there is an aspect i do not understand
  4. I

    joining 2 fields on a form and populating into a third

    I have tried all but by putting in the Me. or Me! in AfterUpdate code it comes up with an error so I did it with only [Prod Code] = [Style Code] & [ Colour Code] and the value appears in Prod Code on the form. But it doesn't save it and also when i add a new record that value stays I would...
  5. I

    joining 2 fields on a form and populating into a third

    Oh by the way - i am using Access 2010
  6. I

    joining 2 fields on a form and populating into a third

    I have tried all but by putting in the Me. or Me! in AfterUpdate code it comes up with an error so I did it with only [Prod Code] = [Style Code] & [ Colour Code] and the value appears in Prod Code on the form. But it doesn't save it and also when i add a new record that value stays I would...
  7. I

    joining 2 fields on a form and populating into a third

    Thanks for the reply so promptly I tried what you suggested and it comes back with The expr after update produced the following resulr - The object doesn't contain the Automation object 'Me." This is the expression I used =[Me]![Prod Code]=[Me].[Style Code] & [Me].[Colour Code]
  8. I

    joining 2 fields on a form and populating into a third

    Hi all Have played around with Access for quite a while. Even after trawling the net - i cannot find the answer to this. I know that it is not the ideal thing to do- but please humour me. I am tryin g to create a product number based on the selected codes There are 3 fields Style code...
Back
Top Bottom