Use query to Filter Results from another query.

[november]

Hrmm, lets see if I can explain this.

I have a query that outputs to a continuous form. Because of how this query is made I'm unable to edit the data on the continuous form.

I will have to make an "update form" and wanted to know if there was a way to view the table that needs to be updated in a datasheet with the results from the continuous form.

Does this make sense?

 

[tebule]

I am having a similar problem. My post is on the site too. But mine isn't with forms. For yours you can make a sub form that when it opens, it's source would be the query from the continuous form. That hard part is pulling the data from the record that you are on.

You could do that if you made the previous query a recordset and used a pointer and then make a subrecordset with the data off of that record.

Does that make sence?
Thanks,
Tebule

 

[Bilbo_Baggins_Esq]

That hard part is pulling the data from the record that you are on.

You accomplish this by linking fields from the main form to fields in the sub-form

 

[tebule]

Bilbo's way is simpler! Which is always best.

 

[november]

Elaborate on said linking please.

 

[tebule]

Do a google search for linking fields and VBA or Access

 

[Bilbo_Baggins_Esq]

When you build your Sub-Form (using the wizard), it will ask you if you want to link fields from the main form to fields in the sub form, and give you multiple fields to select.
It's pretty self explanatory and you'll know it when you see it.

 

[november]

What about using a make-table query to compile the data that each PM should represent, then updating that information in the continuous form and later updating the preceding information accordingly.

Does this sound like something that can be done?