Value from Form to Subform - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Value from Form to Subform

Robert Sena

4 years ago

Pic is attached.  I want the Contractor on my subform to copy to the related record in my sub-subform.  The row source of my subform is
SELECT [ContractorT].[ContractorID], [ContractorT].[ContractorName] FROM ContractorT;
(Note name of combo box is Combo30)  When I use the control source forms!ContractorProjActivitiesSubformF!Combo30, I get the Contractor ID.
I want the ContractorName shown instead.  Subform Name = ContractorProjActivitiesSubformF.  Any idea on what I am doing wrong.

	Kevin Robertson @Reply 4 years ago
You are being returned the first column (column 0) in the combo box (usually the ID). The ContractorName will be in the second column, so to get that value say `Combo30.Column(1)`. Note: Combo30 is not a very meaningful name, especially if you need to refer to it.

	Robert Sena OP @Reply 4 years ago
Ok thanks. I usually use better naming schemes. I need to revise it.

	Kevin Robertson @Reply 4 years ago
Also watch the Value From A Form video for the correct syntax when referring to a subform.

	Alex Hedley @Reply 4 years ago
> I want the Contractor on my subform to copy to the related record in my sub-subform. Are you adding the `ContractorId` then doing a query to pull it in (or `DLOOKUP`)

	Robert Sena OP @Reply 4 years ago
I am adding the query on my main form combobox using the ContractorID but returning the ContractorName. I am not using DLOOKUP. I am using the expression forms!formname!comboboxname to return the value from my main form to subform. Still on my subform, I am getting just the ContractorID. The contractor name is correctly displayed on the mainform

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View