Hey all, new to access so please excuse my lack of knowledge.
I'm sure this is pretty simple to do but I have a 11 week old baby so I don't have as much time as I used to . Let's see if I can be not so confusing here...
OK, so I have a "home" page form. On there, I have a sub form "ContractorsSubform" that lists the contractors that I work for. I have it so that if I click on the contractor ID number in the sub form, it opens up a form that shows all the contractor information; i.e. company name, rate, etc.. called simply "Contractors".
On this same "Contractors" form, I have a sub form called "ContractorsCustomersSubForm" that lists all the customers that go with that specific contractor; it has limited info just to identify the customer and like the home page; I can click on the CustomerID and go directly to the customers information form "ContractorsCustomers". Al this works.
My problem(s)...
I have a button on the "Contractors" form called "New Customer". So when I click on a ContractorID, it takes me to the specific contractor. There I have the button "New Customer", I want the form "ContractorsCustomers" to open so that I can add a new customer to that Contractor. When I click my button, it does open up the blank form; however I don't know how to tie it to the currently selected contractor. The result is when I add a customer, it goes into the table "ContractorsCustomersTable", but it is not assigned to the contractor. If I enter a new record directly into the sub form "ContractorsCustomersSubForm", the record saves. I then can click on the CustomerID and go the full form and add the rest of the data. Sure I could just do it this way, but would be nice to just have a button.
Also, which is part of my disconnect, when this blank form "ContractorsCustomers" opens I need the Contractor Name to show in the company name field and it does not.
I have attached some screen shots. Excuse the layout as I am just trying to get it functioning first.
Any thoughts, suggestions, better ways would be much appreciated.
Thank you!