User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 429,888 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,326 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums

Pass arguments to a Function

Join Date: Mar 2008
Posts: 34
Reputation: clueless101 is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 0
clueless101 clueless101 is offline Offline
Light Poster

Pass arguments to a Function

  #1  
Mar 31st, 2008
I am to create a form with 2 text boxes to receive numbers as input and 1 command button that displays a message box containing the larger of the two numbers. To do so, I need to write code in the Click event of the command to call a user-defined function named FindLargestNumber. Pass it 2 arguments(textboxvalues) and display the result in a message box. Write code in the FindLargestNumber function to determine the larger number and return result to the calling procedure(command button Click event).

Can anyone help me out on this? Here's my code thus far, which isn't working:
Option Compare Database

Private Sub cmdCompare_Click()

If Number1 > Number2 Then
MsgBox "txt.Number1.value"
ElseIf Number2 > Number1 Then
MsgBox "txt.Number2.value"
End If

End Sub

Public Function FindLargestNumber(Number1 As Double, Number2 As Double)


End Function
AddThis Social Bookmark Button
Reply With Quote  
All times are GMT -4. The time now is 8:45 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC