Sub form on continuous view

[Hotwhelz]

I have a continuous view form.
I have another table with data that relates to the records on the continuous view form.
I would like to show the data from the outside table for each record in the form.
Since Access (2000) will not allow subforms on continuous view forms, how is the proper way to do this?

Thanks

 

[Remou]

You could have:
* a continuous form based on a query joining the two tables * a form that opens off the continuous form on say, double-click of the ID.

 

[Hotwhelz]

If I understand what you are saying, I have tried that and it results in duplicate records.
So if the second table has 3 entries in relation to the 1st table I end up with three records if I run that query.
Right now I have command button that opens a separate form based on a different query. People are complaining about having to open the extra form.

 

[Remou]

If you do not need to update the continuous form, it may be possible to set up the query to show only one record. If you post the table schemas, and a note on what you would like to appear, it would be possible to give a more detailed answer.

 

[MajP]

You can put two continous subforms on a main form and synchronize them. As select a record in subform one, subform 2 shows all related records. There are several different ways to do this. Read the FAQs on synchronize forms. I simply do it this way.
1. put a hidden text box on the main form called "txtBxLink"
2. on the "on current" event of subform 1 set the value to the primary key of the current record.

in subform 2 in the
link master : [txtBxLink]
link child : yourForeignKey