I'm working on building a database through Access 2010 which will keep track of jobs and "records" (here, essentially components of a job, like a bid). These two aspects of a job are in their own, separate tables, with the Primary Key of the JobT Table being a foreign key in RecordT. I currently have a Navigation Form set up with a subform that displays a list of current records/bids. At the end of this subform, I have a button labelled "Job Info" that leads to a different form that displays all the details of this job, and includes a subform of the bids that make up a job. There is another button, right next to this one, that opens a form with details about the bid (call it Record Info). Both of these forms allow reading as well as writing information, and this is by design.
My question is: is there any way to open the "Record Info" and pass specific values to certain fields on the new form? In this case, I'd like to pass only the JobID value into the new form only when the button on the Job Info form is pressed (along with other job-specific things that can be brought over if I have this JobID field (which is a Primary Key)).
Essentially, I would like to re-use the Record Info form thusly:
1: pressing the "record info" button at the end of a line in a subform should open that record's information.
2: pressing the "log new record" button (on the Job Info form) should open this form in data entry mode, automatically passing and pulling certain information based on information in the form that called this one.
The end result of this form's submittal should be that the new record is added to the RecordT table, and it should be automatically assigned to the appropriate job. This can be accomplished using a dialog box or text/combobox, whichever seems simpler.
Thanks in advance!