Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

a how do you reference controls and forms in vba function

Status
Not open for further replies.

uscitizen

Technical User
Jan 17, 2003
672
US
let's say you have a form and you want to apply a pair of nested functions to a control on it, Nz(DMax()) for example.(the reason is probably not material, but you want the code to increment a control by 1 for each record up to a maximum of 10). let's say you left some spaces when naming your cotnrols and form name, e.g. controls called "patient number", "lesion number" and a form name of "recist: disease evaluation - target lesions". you want to evaluate the maximum value of lesion number in this form for a patient(while incidentally the user is looking at a filtered subset of records - filtered by patient number as a result of the functioning of a macro. is there a good rule of thumb for when to use square []s, "" marks, !!!hyphens and/or examples.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top