Coding Problem

[Drunkenneo]

I have a database on which if i click on the call button it takes the number as it was when the opening of the database, Please help:

Private Sub Command54_Click()
On Error GoTo Err_Dial_Click

contact_number.SetFocus
Call Shell("C:\Program Files\Excel Dialer Pro\phoneex.exe", vbNormalFocus)
On Error GoTo Err_Dial_Click

Exit_Dial_Click:
Exit Sub
Err_Dial_Click:
MsgBox Err.Description
Resume Exit_Dial_Click

 

[pr2-eugin]

Sorry what..

 

[Drunkenneo]

on the opening of database i got a phone number in auto dialer as xyz and when on the next data where the phone number is abc on clicking on call it is xyz only.

 

[pr2-eugin]

What is your Form set up? Single Form? What is the Code that calls the first number?

 

[missinglinq]

I second Paul's "Sorry what..," but from the somewhat confusing description I'm assuming that this is a Continuous View Form, and I think you need to actually select the Record whose phone number you want to call before clicking on the dial button.

An alternative might be to replace the dial button with a Textbox tweaked to look like a Command Button and use its OnClick event to dial. In that way the Record would be selected prior to dialing.

Like Paul, I see that you move Focus to contact_number but no code that actually utilizes the number.

Linq ;0)>