Hi All,
I created an NCR database (NCR = non-conformance report) in which I want to be able to create new NCR's and also to update existing NCR's.
I created 2 buttons for each function. In each case a new form will pup-up until all necessary data is introduced (data introduced to the table through the form).
Now, in the case of "updating existing NCR's" I created a combo box which shows all existing NCR numbers in the table. At a push of another button, let's called it "OPEN NCR FORM" I want to automaticcaly open the NCR form with all the data from that particular NCR number. I am attaching the database for a better understanding of the situation (First open form called "NEW or OLD").
Another issue that I have is that I am not able to record data in the same line.
Every new NCR begins with a NEW NCR number. To this NCR number will ALL other data be connected, therefore I need them on the same line as the NCR number (same record).
I would appreciate if somebody could help me figure out where's the problem as I am a novice with Access database creation.
Million thanks...
I created an NCR database (NCR = non-conformance report) in which I want to be able to create new NCR's and also to update existing NCR's.
I created 2 buttons for each function. In each case a new form will pup-up until all necessary data is introduced (data introduced to the table through the form).
Now, in the case of "updating existing NCR's" I created a combo box which shows all existing NCR numbers in the table. At a push of another button, let's called it "OPEN NCR FORM" I want to automaticcaly open the NCR form with all the data from that particular NCR number. I am attaching the database for a better understanding of the situation (First open form called "NEW or OLD").
Another issue that I have is that I am not able to record data in the same line.
Every new NCR begins with a NEW NCR number. To this NCR number will ALL other data be connected, therefore I need them on the same line as the NCR number (same record).
I would appreciate if somebody could help me figure out where's the problem as I am a novice with Access database creation.
Million thanks...