Pass value from form to popup form

[solun]

This seems like it should be so easy...

I've got a form, 1Loan, with an LoanID field. I want to use a command button on 1Loan to open a form, sysApps, that will only display the multiple records from a different table that have the same Loan ID.

This code gives me an error on the "sysApps!loanid=lid" line: Object required. Without that line, i get nothing.

What am I doing wrong?

    Dim stDocName As String
    Dim stLinkCriteria As String
Dim lid As Double

lid = Me!LoanID
    stDocName = "sysApps"
    
    stLinkCriteria = "[LoanID]=" & lid
    DoCmd.OpenForm stDocName, , , stLinkCriteria
    sysapps!LoanID = lid

 

[RoyVidar]

Isn't this more a forms question (forum702?)

Anyway, if you want to push the value, try referencing through the forms collection

[tt]forms!sysapps!LoanID = lid[/tt]

Else try passing the value through openargs - some approaches should be available through search

Roy-Vidar

 

[solun]

okay, that makes nice new records with the proper LoanID with no error but doesn't show me the existing records with that loan id.

i realized after I posted this that it was a forms question not a vba question, so i reposted there. i'm sorry. thanks for answering anyway.

 

[PHV]

Check the DataEntry property of the form "sysApps".

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886