I have a main form (form a) which enters data into a main table (tbl a)
then I have a parameter query which filters the data by up to 6 fields and displays it in database view.
Then I have another form which displays the filtered data in its entirety (looks like the first form)
Now in the event of data changing…I need to be able to query through the DB and find the desired job and change the data in the last form and have it carry through to the table.
I'm sure their is an easy answer, but my lack of access savvy is just keeping me from reaching it.
Any help would be really appreciated!
Thanks
Sean
additional info- (currently if I go into the main tables spreadsheet view and change infromation it carries through on the forms, and if I go into the fist form and make changes, they also carry through, I'm not sure how to recreate that relationship)
then I have a parameter query which filters the data by up to 6 fields and displays it in database view.
Then I have another form which displays the filtered data in its entirety (looks like the first form)
Now in the event of data changing…I need to be able to query through the DB and find the desired job and change the data in the last form and have it carry through to the table.
I'm sure their is an easy answer, but my lack of access savvy is just keeping me from reaching it.
Any help would be really appreciated!
Thanks
Sean
additional info- (currently if I go into the main tables spreadsheet view and change infromation it carries through on the forms, and if I go into the fist form and make changes, they also carry through, I'm not sure how to recreate that relationship)