Conversion to Acess 2007

[Gordon]

I have just upgraded from Access 2003 to Access 2007 and converted my
database. All is well, except one form appears to be broken.

The form (frmDiscography) is based on data from three tables.

1) tblMusicography (PK = fldMusicID) - also contains fldTrackID)
2) tblTrackTitles (PK = fldTrackID) - also contains fldMusicID
3) tblDiscTitles (PK = fldDiscID) - also contains fldTrackID

The form allows the user to select a film title (from tblMusicography)
from a combo box (SelectFilm) in the form header

The form is based on tblMusicography. On the detail of the form, there
are 2 subforms.

1) fmrDiscographySubform1 shows the discs which contains tracks from
the film selected
2) frmDiscographySubform2 shows the track titles from the disc
selected in frmDiscographySubform1.

The primary relationship is between the main form and subform2. For
subform2, link master field is "fldDiscID;fldMusicID", as is the link
child field.

For subform1, the link master field is fldMusic ID as is the link
child field.

On the main form there is a hidden text box whose control source is
"=frmDiscography!frmDiscographySubform1.Form.fldDiscID".

In the afterupdate event of the SelectFilm combo box in the header,
there is the following code:

DoCmd.ApplyFilter , "[fldMusicID] = Forms![frmDiscography]!
[SelectFilm]"

As I say, in Access 2003 this from worked fine. Now that I have
converted to 2007, when I select a film title from the SelectFilm
combo, nothing happens.


What has gone wrong?

Giordano

 

[Allen Browne]

Gordon, did you tell A2007 that your database was in a trusted folder:
Office Button | Access Options | Trust Center | Trust Center Settings

If you did not, that might be why the VBA code is doing nothing.

 

[Gordon]

Hi Allen,

Thanks for replying. Tried your suggestion but regrettably no joy. I
did notice a "?name error" in the hidden linking box to which I
referred in my original post when I unhid it. Is that significant?

Gordon

PS My second time in posting this - first one seems not to have
registered.

 

[Allen Browne]

Yes: the #name in the text box would indicate that something is wrong.

One possible cause would be if the text box has the same name as a field,
but is bound to something else (an expression or another field.)