All,
I am have been trying to figure out a way to link data from one form to the other with no joy i am a novice at best. My situation is I have a form called Run Query and it get four lines of data updated when the user enters a serial number it also has an OverRide button that should ask for and verify employee name and his/her security code which is stored in a table called AuthorizedUsertoOverride then pass that data to another form call OverRide Table which displays all data and has button on it called commit which will wright the data to a table called OverRide Table. But as of yet i have no clue as to how to do this. I have the forms and the tablescreated but can not get the fields to interlink with each other and do the checks i need if anyone has some suggestions i would love to here them.
Paul
I am have been trying to figure out a way to link data from one form to the other with no joy i am a novice at best. My situation is I have a form called Run Query and it get four lines of data updated when the user enters a serial number it also has an OverRide button that should ask for and verify employee name and his/her security code which is stored in a table called AuthorizedUsertoOverride then pass that data to another form call OverRide Table which displays all data and has button on it called commit which will wright the data to a table called OverRide Table. But as of yet i have no clue as to how to do this. I have the forms and the tablescreated but can not get the fields to interlink with each other and do the checks i need if anyone has some suggestions i would love to here them.
Paul
