<div>
If the vendor should always be the same for all records in the subform, then vendor is in the wrong table. &nbsp;If you want it to be mostly the same but allow overrides, then add a vendor combo on the main form and in the BeforeInsert event of the subform, populate the subform vendor with the default from the main form combo.<br />
<br />
Me.VendorID = Forms!mainform!cboVendorID<wbr /><br />
<br />
Then they can change the vendor one at a time as necessary.
</div>


If the vendor should always be the same for all records in the subform, then vendor is in the wrong table.  If you want it to be mostly the same but allow overrides, then add a vendor combo on the main form and in the BeforeInsert event of the subform, populate the subform vendor with the default from the main form combo.

Me.VendorID = Forms!mainform!cboVendorID

Then they can change the vendor one at a time as necessary.

<div>
Would it be possible to make the vendor combo appear as if it was a part of the sub form?<br />
<br />
I understand conceptually what you are saying, but I am having a hard time figuring out how to integrate it in my current layout.
</div>


Would it be possible to make the vendor combo appear as if it was a part of the sub form?

I understand conceptually what you are saying, but I am having a hard time figuring out how to integrate it in my current layout.

<div>
<div class="content wysiwyg-content">
This is a additional question in regards to the last question I asked &quot;Combo Box with a control source is &quot;locked&quot;&quot;<br />
<br />
Rey's solution of choosing Dynaset with Inconsistent updates did the trick. &nbsp;<br />
<br />
Is it possible to get the the Vendor Combo Box to default to the same value for all stores when I choose the vendor for the top store? &nbsp;If I want to choose another vendor for a certain store I would do it after.<br />
<br />
How would this be accomplished?
</div>
</div>


This is a additional question in regards to the last question I asked "Combo Box with a control source is "locked""

Rey's solution of choosing Dynaset with Inconsistent updates did the trick.  

Is it possible to get the the Vendor Combo Box to default to the same value for all stores when I choose the vendor for the top store?  If I want to choose another vendor for a certain store I would do it after.

How would this be accomplished?

Combo Box with a control source is &quot;locked&quot; part II - choosing vendor for first store would be the default value for all stores

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Combo Box with a control source is &quot;locked&quot; part II - choosing vendor for first store would be the default value for all stores

Combo Box with a control source is "locked" part II - choosing vendor for first store would be the default value for all stores