I have been working with Access 2007 for some time and usually have no problem that I can't get resolved via forums on the net. I have starting wanting more and more AI features with my software development which is my reason for posting.
I have a main table that holds the unique information fields. I have created a query and based my forms on the query. To keep it simple, I have a field that is called File Number - which is a numeric field to prohibit duplicates. I have another table that holds actions taken on the files in the main file and a subform has been created to show the actions taken when a specific file is searched for. This all works great. When I have searched for a file number and its displayed in a form with a subform showing the actions that have been taken - I want to be able to add another action while on this form. I have created a form that works well for this purpose - however - I must manually enter the file number into the file number field on this "new action" form. What I would like is to have the file number filed auto-populate with the file number on the main screen with the subform so that there is no possibility of error. I have tried multiple ideas from examples on the internet but nothing worked. I actually got the field to populate once but it would not save the file number in the new record so the addition did not show up in the subform of actions taken.
This is what I would like help with : how to get a new record in a separate table to autopopulate the file number field with the file number value on a form that is based on a query. This new table will be used as the source of the subform to show all the actions taken on that file.
I have included the access db file for you.
Thanks
Scott