J
Justin
I am having this dilemma. I created this database for the cash management
dept of my company. Now one part of the database checks to see if our records
on file is equal to a third party's record. If both records are equal, great,
go to the next set of record. But if they aren't equal, then the user has to
select the record ( i made a subform that will automatically show which
records aren't equal) and add comments to it on another form.
My problem is that user click on the record to add comments, like i said
before, it will bring them to the comment form (which will include all
neccessary information about the data) but that form is blank. Now, I see the
only way to have the form populate automatically with the data if the table
already has all the data that aren't equal already there. I tried to do as
soon as both files has been loaded, then have a query to append it to the
table. Problem is that everytime the database is loaded, the files are being
duplicated.
I just want to have a way that the user sees all teh unequal data on the
subform, clicks on the data, brings them to another form wher ethey can add
some comments, save it and have it stored in a table for later use. Please
help
dept of my company. Now one part of the database checks to see if our records
on file is equal to a third party's record. If both records are equal, great,
go to the next set of record. But if they aren't equal, then the user has to
select the record ( i made a subform that will automatically show which
records aren't equal) and add comments to it on another form.
My problem is that user click on the record to add comments, like i said
before, it will bring them to the comment form (which will include all
neccessary information about the data) but that form is blank. Now, I see the
only way to have the form populate automatically with the data if the table
already has all the data that aren't equal already there. I tried to do as
soon as both files has been loaded, then have a query to append it to the
table. Problem is that everytime the database is loaded, the files are being
duplicated.
I just want to have a way that the user sees all teh unequal data on the
subform, clicks on the data, brings them to another form wher ethey can add
some comments, save it and have it stored in a table for later use. Please
help