Full Version: SetValue in vba
UtterAccess Forums > Microsoft® Access > Access Forms
tomas
Apr 12 2005, 10:16 AM
Simple question - I have NO vb skills (as yet) and I need to know how to carry out the setvalue macro command in vba.
I have a form opening on an "on not in list" event so that a new drop down optoin can be added and I want to carry across the new value that was typed in from the main form to this new value form.
Is there a simple line of code to carry the value across??
It's driving me mad, but I simply don't know the syntax of vba...
Thanks!
BrianS
Apr 12 2005, 10:20 AM
yeah as long as both forms are open at the same time
orms!YourFormName!YourControlName
ex
CODE
Private Sub Form_Load()
Me.txtMyBox = Forms!frmMyForm1!cboMyBox
End Sub
tomas
Apr 12 2005, 12:07 PM
Brian
Thank you very much, works fine and I finish day a satisfied man.
Tom
BrianS
Apr 12 2005, 12:51 PM
Glad to hear it!
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.