I've got a form which is used as a pop up for selecting a customer and a project, we will call this form frmCustomer for arguments sake. The first form will be used to select data for the quote, and in order to associate a customer and project, the user has to click a button which will open up the frmCustomer form.
Originally I had it so a subform in datasheet view will be used to select (and enter new) customers, where there will be a text box in the main form which shows the ID of the currently selected record in the subform. This worked perfectly well.
However, I have noticed that next to each customer record there is a + sign which upon click, drops down all the projects associated with the customer. This is a great idea, as it also allow you to add new project records. However is there any way I can reference the project?
I know how to reference the customer as it is “=[CompanySubform]![CompanyID]”, but I want to be able to choose the sub-record (the project) as well.
Any help will be appreciated.
Originally I had it so a subform in datasheet view will be used to select (and enter new) customers, where there will be a text box in the main form which shows the ID of the currently selected record in the subform. This worked perfectly well.
However, I have noticed that next to each customer record there is a + sign which upon click, drops down all the projects associated with the customer. This is a great idea, as it also allow you to add new project records. However is there any way I can reference the project?
I know how to reference the customer as it is “=[CompanySubform]![CompanyID]”, but I want to be able to choose the sub-record (the project) as well.
Any help will be appreciated.
