Copy record in the subform if the NoOfPayments value is 2

[hrprabhu]

Got it working a bit, but, have a look at the attachment Please.

When I input No. Of Payments equals to 2, it is prompting me to input the IDLPA, how do I get around it? It has to pick up the IDLPA automatically.

Thanks

Raghu Prabhu

[jimatqsi]

Is IDLPA the name of a column in a table? Is it spelled correctly? It's asking for the value of that because your select statement includes that but there is no column with that name. It thinks that's the name of a parameter you will supply.

Jim

[zmbd]

Please understand, many of us cannot or will not d/l un-requested attachments. This has absolutely nothing to do with who you are... In my case, such d/l are prohibited by my ITSec staff. For many others, it is part of "safe computing/best practices" not to d/l such files. A practical example as to why can be found here http://bytes.com/topic/access/answer...l-ms-products. this unfourtunate Member opened a file from a trusted source and is now haveing all sorts of issues!

SO, Please, take a few moments to look at your tables, queries, and forms. If you can't find the typo yourself then you can post back with the underlying code and/or VBA script.

[hrprabhu]

Thank you sorted out the problem.

[zmbd]

Would you mind posting how you solved the issue?

[hrprabhu]

Hi zmbd, here it is ....Just worked it out. I was trying to copy the LPAID too and it was causing the problem. After I realised that then I was finding it was not updating if I input 2 a couple of times.

Private Sub noOfpays_AfterUpdate()

    Select Case noOfpays
        Case 1
            'do nothing
        Case 2
            Me.Dirty = False
            DoCmd.OpenQuery "Query1", acViewNormal, acEdit
            Me.Requery
    End Select
    
End Sub

This is working now.

[hrprabhu]

Also in the query I have to put this in the criteria for IDLPA

[Forms]![frmMain]![subFrmLPA].[Form]![IDLPA]

Thanks zmbd