I have a form for employees reviews that has a 45 days and a 90 day review, w my question is the following: After i input the 45 day review how can i go back edit that and add the 90 day review and save that as a new record with a new record Id?
I have a form for employees reviews that has a 45 days and a 90 day review, w my question is the following: After i input the 45 day review how can i go back edit that and add the 90 day review and save that as a new record with a new record Id?
You may wish to revisit your basic db design. I would think each review would be on a separate record.
Yeah I thought about that, but this is a review for temporary employees an I don't get that many, and the form that I have has two blocks, one for the 45 days and another for the 90 days review. if you would like i can post a screen shot of the form?
I presume your table has a field for each of the combobox items. And you want to display two records horizontally on form. Can't do that with normalized data and bound form.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.