Urgent Asccess Help Required

[sam_antoine]

I am trying to open a subform/popup form to allow only a manage to update payment mistakes. I am using a command button to open the popup form. I can successfully open the popup form showing the current job being dealt with if I have no password dialog.

However, if I password protest the command button (that is to saw open a password dialog box), on clicking ok, the popup form opens displaying the first record. Is there any way I can password protect the command button and open the popup form to the current record being dealt with?

I hope you can understand what I am trying to do here. Many thanks in advance

 

[sam_antoine]

I do not understand what you are asking. I have a form called jobsheet and on that form I have a command button, which when pressed opens a password dialog form. I think what I need is to make jobNo on the Jobsheet form = Jobno on the password dialog so that the ok will check that the JobNo on password dialog= JobNo on the paymentupdate form. At the moment I use a macro for the password dialog, but there is no expression in the where condition.

This is the code that works without the password dialog
Private Sub UpdatePayments_Click()
On Error GoTo Err_UpdatePayments_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "ClientPaymentUpdate"

stLinkCriteria = "[JobNo]=" & Me![JobNo]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_UpdatePayments_Click:
Exit Sub

Err_UpdatePayments_Click:
MsgBox Err.Description
Resume Exit_UpdatePayments_Click

End Sub

 

[sam_antoine]

I am dealing with 3 forms. How do I make JobNo on the master form = JobNoon the passwordDialog form and then to make JobNo on the paswordDialog = JobNo on the PaymentUpdate form. I have tried it in everyway possible but it just wont'word. I get a name error on the passworddailog form for JobNo.

 

[sam_antoine]

I got it to work. I simply changed my record source and rebuilt the forms. It works a charm.