DLOOKUP and Forms

[Scooby62]

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]")

 

[Remou]

Perhaps:

[tt]DLookUp("[CommonName]","tblBotNames","[BotanicalName]='" & [Forms]![frmDataEntry-Main]![frmEntry Detail Subform].Form![Botanical Name] & "'")[/tt]

 

[Scooby62]

Oh thank you. Works perfectly.

Thanks again.

Excellent!