Hi there.
I’m trying to update one field on a sub-form once the value of another field on the same sub-form is selected from a combo box. I wrote a macro using the SetValue command.
In the ITEM area of the macro I have:
[Forms]![frmDataEntry-Main]![frmEntry Detail Subform].[Form]![IntName]
In the EXPRESSION area of the macro I have:
DLookUp("[CommonName]","tblBotNames","[BotanicalName]=[Forms]![frmDataEntry-Main]![frmEntry Detail Subform].[Botanical Name]")
I’m trying to update one field on a sub-form once the value of another field on the same sub-form is selected from a combo box. I wrote a macro using the SetValue command.
In the ITEM area of the macro I have:
[Forms]![frmDataEntry-Main]![frmEntry Detail Subform].[Form]![IntName]
In the EXPRESSION area of the macro I have:
DLookUp("[CommonName]","tblBotNames","[BotanicalName]=[Forms]![frmDataEntry-Main]![frmEntry Detail Subform].[Botanical Name]")