Hello all and thanks for looking,
I have a lot of part number information to put in to my database I broke it down into lots of tales per section for each part number so I would not have one table with 100 fields in it. when entering all the data I want to open the form for each table add in the info and then move on to the next table in the end I will have one report with all the information on it. but I want each table to have the same ID label for each part number is there a smile way to do this I was trying to use VBA to copy the ID number form the 1st table to the next but its not working out so well.
thank you
I have a lot of part number information to put in to my database I broke it down into lots of tales per section for each part number so I would not have one table with 100 fields in it. when entering all the data I want to open the form for each table add in the info and then move on to the next table in the end I will have one report with all the information on it. but I want each table to have the same ID label for each part number is there a smile way to do this I was trying to use VBA to copy the ID number form the 1st table to the next but its not working out so well.
thank you