direction on editing a property of...

[mark kubicki]

VBA is familiar to me (in an seasoned, but elementary way...); this is a
whole new area to me

Prior to my arrival, an former employee of the firm wrote an ACCESS project.
In it there is a line of command button with code which automatically enters
text into a text box. The entry is concatenated from entries in other fields
on the form. It has some terrible grammar and one blatant TYPO (which,
because it is entered into a text box, can and is then edited constantly and
consistently be everyone -UGH!

I'd edit the code, but need direction about getting into he right area....


behind the command button is:
Private Sub Command328_Click()
Me.basedescription = Me.autodescription
End Sub

I find the following:
Classes: Form_spec
members of 'Form_spec': autodescription

Please point me to where should I be to edit the "autodescription"

thanks in advance,
Mark

 

[John Vinson]

Private Sub Command328_Click()
Me.basedescription = Me.autodescription
End Sub

I find the following:
Classes: Form_spec
members of 'Form_spec': autodescription

Please point me to where should I be to edit the "autodescription"

There is evidently either a control (textbox?) on the form named
autodescription, or a field in the Form's Recordsource query with that
name. There's a dropdown list of controls in the form design toolbar -
see if there is such a textbox, and if so, see what its Control Source
property might be. This will either be or point to the text you want
to edit.

John W. Vinson[MVP]

 

[mark kubicki]

AH... I see (my background is XL...) this is new 4 me


thanks,
mark