docmd.openform wont open to selected record - help please!

[aytee111]

Thinking about your posts - don't despair! It may be a tough l earning curve but you will get there, and soon. Separate the obstacles and handle one at a time.

[AishlinnAnne]

Post the SQL for the query I spoke of in post #13.

The field you are trying to reference is on the main part of the form, not on the subform.

- open form
- filter on quote number (in the OpenForm statement)
- use quote number as link to subform
- subform will show records for that quote number

Tab pages have no part to play in this, you can leave that out for this issue.

In post #11 I presumed that the links had been fixed since the original posting of your db - is that a correct assumption?

The WHERE statement from the query after inputting criteria and switching to SQL view reads

 WHERE (((qryProjectDetails.QuoteNumber)="16072583B"));

I don't know, maybe I am just dense, or tired.. but I do not see how this is any different than the code I am putting in VBA for lstResults_DblClick event

 DoCmd.OpenForm "frmTabbed", , , "qryProjectDetails.QuoteNumber = ' & Me.lstResults.Column() & '"

When you say Use QuoteNumber as link to subform- You mean make sure that the "Link Master Fields" and "Link Child Fields" are both equal to QuoteNumber for all three tabs, correct? If so, that is how it is set up now.

Also, yes, #11 is working fine now.

Thank you again!!

[AishlinnAnne]

I got it working!!!

    DoCmd.OpenForm "frmTabbed", , , "QuoteNumber = '" & Me.lstResults.Column(0) & "' "

YOU GUYS ARE THE BEST!

[aytee111]

DoCmd.OpenForm "frmTabbed", , , "qryProjectDetails.QuoteNumber = '" & Me.lstResults.Column(?) & '"

Missing end of string closing double-quote, remove query name, either put in a column number or leave that parameter out altogether - otherwise PERFECT!!

Yes, that is the way to link subforms to main forms - and not tabs, they don't come in to play here, only subforms are linked (getting the jargon right!).

[aytee111]

Well done, our posts crossed in the air, you didn't even need me!!