subforms, record selectors and opening other forms

[mackyrm]

Access 2003
---------------------


I am having a problem with opening a form from a sub form. I don't know how to access the subform record selector property on my master form.

I have a master form (A) built on a table (table A) . The master form has a sub form(B), built on a table (table B).

Sub form(B) is in the data sheet view, and record selectors are visible. I would like to be able to open another form (form C), by selecting the primary key on subform B (currently selected record via the record selector!) and
open form C.


The table structure is as follows:

table A: (one) -----< table B: (many)
table B (one) -----<table C: (many)

Any help appreciated!

 

[MStef]

Look at "DemoSubSubA2000.mdb" (attachment).

 

[mackyrm]

Thanks for this.

Not quite sure if this is the right solution, I may be missing the point though!

I am looking to open a new form, based on an ID in an embedded datasheet - there are numerous IDs displayed in this sheet - I only want to use the ID in the row that has the record selector highlighted...

Can this be done?

 

[mackyrm]

Solved

Managed to get this working. I was over complicating the issue! You can put a button on a form and reference the sub form using the standard referencing format for sub forms from a master form.

When using a field within a sub form in datasheet view, to open another form, access will allow you to do this on the currently selected record in datasheet view e.g. if you have 10 rows and you have row five highlighted, the button linking criteria for the primary ID in the subform - will automatically use the primary key in row five to open the new form based on the primary key in that form.

I had thought that there would have been some specialised property that I would have to access on the subform for a selected row, but happily, this is not the case.