How to Fetch the active row Data In a Continuous Forms and display in a new form?

[johny6685]

Hi Team,

I am developing a workflow tool which will actually show all the processed data in a Continuous Forms from a table. Now I have a unbounded command button for each row. on click of a command button a XXXX form should open and the data in the active row or the data in the start button row should be displayed in the XXXX form.

Please help me how to acheive this.

My current code below doesn't help me out on this, and I am not sure how to complete this.

Private Sub cmdStartQC_Click()
DoCmd.OpenForm "frmClaimQCScreen", acNormal, "", "CaseSF = '" & CaseSF.Text & "' AND [ProductionDt] = #" & ProductionDt.Text & "# AND [ProcessorID] = '" & ProcessorID.Text & "'"
End Sub

[twinnyfo]

johny,

Try slight mod below:

Private Sub cmdStartQC_Click()
    DoCmd.OpenForm "frmClaimQCScreen", _
        acNormal, "", _
        "CaseSF = '" & Me.CaseSF & _
        "' AND [ProductionDt] = #" & Me.ProductionDt & _
        "# AND [ProcessorID] = '" & Me.ProcessorID & "'"
End Sub

See how that works and let us know the results!

[johny6685]

Awesome... This works twinnyfo...

Thanks a lot...

So I missed the formname in it which is why it shows an error?

[twinnyfo]

Yes. Sometimes you have to be explicit with VBA (and I prefer to always be so). I even go one step further and explicitly name all of my text boxes so that I know when I am referring to a Text Box vice referring to an underlying field (they are almost always the same, but sometimes you don't have the field on your form).

So, for example, if I have a text box that has as its control Source the field "CaseSF", then I name the text box "txtCaseSF", and so one. Combo Boxes have a "cbo" prefix, Command buttons are "cmd", etc. In the short run, it is a little extra work when building forms. However, in the long run (and especially when dealing with summing over groups on reports) you want to be as explicit as possible, and troubleshooting can be a bit easier.

Glad we could help again!

[johny6685]

Agreed sir, I use to do that but sometime I fail to do. Thanks