Using Link Criteria in opened form

[willkr]

OK, I'm making progress. Here's my next question:



I'm opening a new form with the following code

stDocName = "frmShowSavingsDepositEntries"
stLinkCriteria = "[Savings Deposit Number]=" & Me![Number]
DoCmd.OpenForm stDocName, , , stLinkCriteria

In the new form, how do I get to the contents of stLinkCriteria?

[Bob Fitz]

Is form frmShowSavingsDepositEntries bound to a table/query ?
Does the form have a control that is bound to a field in the table/query called "Savings Deposit Number" ?

[willkr]

Yes and Yes

[Bob Fitz]

Can you post a copy of your db

[willkr]

Bob,
Thanks, but I got the info I needed.

[Bob Fitz]

Bob,
Thanks, but I got the info I needed.

Good. Care to share it with us.

[willkr]

Sure,
I have been chasing a bug that was causing an error. I've been at it for two days. However, I was looking at the code and the problem was with the select statement for the sub-form. I'm learning a little bit each day.