Combobox with subform for multiple entries.
Posted: Wed Apr 11, 2018 5:30 pm
Hi, I have a form ECNListByCustomer. Currently I am adding the ECNList references in a separate ADD NEW ECN-RFQ form. I would like to simplify matters and have only one form, the ADD NEW ECN-RFQ form.
At the same time it would be hugely beneficial to be able to add PartNumbers associated with the RFQ Reference.
So I am struggling to merge the two forms and make the ECNDetails subform a form to add new PartNumbers and not just show the existing ones.
So the new form lets call it RFQbuilder would be the same as ADD_NEW ECN-RFQ with the following changes,
1) Customer would be chosen first from listbox first this would restrict the RFQ references listed (as in the ECNListByCustomer form).
2) The RFQ Reference field would be a combobox and and would create a new entry if it did not already exist.
3) The ECNDetails or similar subform would allow PartNumbers to be added to the existing PartNumbers.
4) the other fields would remain the same.
I thought it best to show the entire picture of requirement for this form rather. I am happy to receive any advice and help step by step which would help me learn a little at a time.
I have had some of the above working separately, like the partnumber entry in the subform. However bringing them all together has been beyond my very limited capabilities.
Download link http://www.mediafire.com/file/vrl3dj76p ... 0V1.15.odb
At the same time it would be hugely beneficial to be able to add PartNumbers associated with the RFQ Reference.
So I am struggling to merge the two forms and make the ECNDetails subform a form to add new PartNumbers and not just show the existing ones.
So the new form lets call it RFQbuilder would be the same as ADD_NEW ECN-RFQ with the following changes,
1) Customer would be chosen first from listbox first this would restrict the RFQ references listed (as in the ECNListByCustomer form).
2) The RFQ Reference field would be a combobox and and would create a new entry if it did not already exist.
3) The ECNDetails or similar subform would allow PartNumbers to be added to the existing PartNumbers.
4) the other fields would remain the same.
I thought it best to show the entire picture of requirement for this form rather. I am happy to receive any advice and help step by step which would help me learn a little at a time.
I have had some of the above working separately, like the partnumber entry in the subform. However bringing them all together has been beyond my very limited capabilities.
Download link http://www.mediafire.com/file/vrl3dj76p ... 0V1.15.odb