Function help 1

[Darci]

Hi,

Can someone help me write a function that takes the id number and returns the name. For instance, I have an ATM table that contains the related bank id. I want to be able to pass the bank id and return the name.

Thanks

Darci

"If you do what you always did, you get what you always got."

Darci

 

[mikeyb540]

Do you want the Name on a Report or Form?

you can do something like this on Command_click

Private Sub Command_Click()
Dim rs As Recordset
Dim SQL As String
Dim strBankID as string
strBankID = ME!BankId
SQL = "SELECT Name FROM ATM where bankid = " strBankID
Set rs = CurrentDb().OpenRecordset(SQL)
Me!Name = rs("Name&quot
rs.Close
End Sub

 

[funcrecall12]

Create Function ReturnName (@BankId int)
Return Character(50)
AS
Declare @xName Character(50)
Select LName + FName xName from ATM
where bankid = @BankId

Return @xName