mickmullen
Registered User.
- Local time
- Yesterday, 21:39
- Joined
- Oct 30, 2018
- Messages
- 19
Newbie here, I'm having a problem trying to implement VBA.
I have a Form that is working fine, then I turn on the VBA and some controls stop working.
For example, I have a text box control source set to this
=DLookUp("[Project Name]","ProjectLog","[Project Number] =" & [Forms]![WorkOrders]![Project Number])
works great until I try to put some code on a button on the same form. Now I get a popup asking for [Forms]![WorkOrders]![Project Number] entry
I feel like I'm missing a basic concept, or a setting is wrong. Any suggestions are much appreciated.
Mick
I have a Form that is working fine, then I turn on the VBA and some controls stop working.
For example, I have a text box control source set to this
=DLookUp("[Project Name]","ProjectLog","[Project Number] =" & [Forms]![WorkOrders]![Project Number])
works great until I try to put some code on a button on the same form. Now I get a popup asking for [Forms]![WorkOrders]![Project Number] entry
I feel like I'm missing a basic concept, or a setting is wrong. Any suggestions are much appreciated.
Mick