B
Brad Granath
OK.
I've got a form that contains two subforms, one called "Units subform", the
other called "Records subform." The Units subform allows the user to select
a record from the database in Datasheet view. The Records subform displays
the users choice in more detail.
Once the user selects a record from the Units subform, an onClick event
drives the Records subform to requery, using the fields in the Units subform
as SELECT criteria.
Trouble is, it doesn't work. When I select the first record in the database
viola! It works... displays everything perfectly like it should. It does so
for about one third of the records in the database. But for the other two
thirds, it just remains blank. The selection of the records that work and
don't work seems totally random; I can't find a pattern to it at all.
What am I doing wrong?
I've got a form that contains two subforms, one called "Units subform", the
other called "Records subform." The Units subform allows the user to select
a record from the database in Datasheet view. The Records subform displays
the users choice in more detail.
Once the user selects a record from the Units subform, an onClick event
drives the Records subform to requery, using the fields in the Units subform
as SELECT criteria.
Trouble is, it doesn't work. When I select the first record in the database
viola! It works... displays everything perfectly like it should. It does so
for about one third of the records in the database. But for the other two
thirds, it just remains blank. The selection of the records that work and
don't work seems totally random; I can't find a pattern to it at all.
What am I doing wrong?