FUNCTION & SUB PROCEDURE 1

[diggermf]

Hi All

Whats the difference between FUNCTION and SUB PROCEDURE?
Please Clarify

 

[TheAceMan1]

How are ya diggermf . . .

A function [blue]returns data[/blue], subroutine [blue]does not![/blue] . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[danvlas]

Functions may return values.
Subs may not.


Daniel Vlas
Systems Consultant

 

[TheAceMan1]

diggermf . . .

BTW: BTW: Welcome to [blue]Tek-Tips![/blue] Do have a look at one of the links at the bottom of my post. The links will help you [blue]ask better questions[/blue], get [blue]quick responses[/blue], [blue]better answers[/blue], and insite into [blue]etiquette[/blue] here in the forums. Again . . . Welcome to [blue]Tek-Tips![/blue] . . . [blue]Worthy Reading![/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[diggermf]

Thank you TheAceMan1/danvals

 

[boblarson]

Also, just as something to think about - since a function may, or may not return a value and a sub never returns a value, I would argue that with the exception of the subs you are stuck with using (form and report events), functions could be used exclusively. Plus they have the added bonus of being able to be seen and called in the properties dialog and in the builders (if public).

I just gave a presentation on that at the Seattle Access Users Group on the Microsoft campus last month and at the Portland Access Users Group this month.



Bob Larson

http://www.btabdevelopment.com