Pass arguments to a Function

•

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 427,255 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,208 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.

Join our community!

Please support our MS Access and FileMaker Pro advertiser: Programming Forums

Thread Tools Display Modes

Views: 1370 | Replies: 7 | Solved

Previous Post in Thread

Next Post in Thread

•

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

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:

Help with Code Tags

(Toggle Plain Text)

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