Pass value from form to popup form 1

[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

 

[GingerR]

Forms!sysapps!LoanID = lid

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[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.

 

[ssatech]

Solun,

Have tried:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "sysApps"

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


**Make sure your form "sysApps" is set to Continuous Forms

 

[solun]

Yes, that's the default cmd button wizard results, and yes, i've got the form set to continuous (checked, double checked.)

 

[ssatech]

Solun,

Works fine in my example.
Whats the relationship of LoanID to lid. I am assuming you have a 1:Many, LoadID being the 1 and lid being the many.

LoanID being in the table behind your 1Loan form and
lid being in the table behind your sysApps continous form.

 

[GingerR]

is your pop-up form's Data Entry property set to YES? If so, it should be set to NO.


Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html