We have an Excel database with two sheets, the first is the log sheet and the second is a trace form linked to the log sheet. We send the trace form via email through the command “Send to Mail Recipient” > “Send the current sheet as the message body.”
I have started creating the trace form in...
I got the code that enables an option group (opgOPCO) to pop-up whenever I input “0064” into the combo box (cboCCN). However, when I go to the next record (using record selector), the option group (opgOPCO) does not hide even though the combox box contains a value other than “0064.”
Dim bShow As...
I used DLOOKUP for a text box in a form. However, to see the looked-up value, I still have to close and reopen the form. Is there any way to show the looked-up value in the text box by just a mere click? Say for example, I hit the "enter" or "tab" key, the text box would automatically update. :)