No Subform records

[The Shaker]

Hi,

I had a db on a computer system running XP Pro at work. The main form
returns records that show up in a subform.

When the db was relocated to another computer system at another place of
work, the db returns NO records in the subform.

Then I took this db to my own computer at home to investigate the problem,
the db began to work properly, returning records in the subform. No changes
have been made to the db.

Could someone please explain what is happening here?

Thanks.

Adam

 

[Maha Arupputhan Pappan]

Adam,

I suspect some library files is not stored in the other PC. I suggest you to
check all the references while working in your PC and ensure that all
references are store in the other PC and in the exact location.

To check the reference, start the DB and go to the code editor, Click Tools

References.

Hope this is helpful.

 

[The Shaker]

Thanks Maha.

Using a test db.

I've unchecked everything except for "Visual Basic for Applications", and
"Microsoft Access 9.0 Object Library". These are "in use" and cannot be
unchecked. System still works fine in my PC. It continues to return records
in the subform.

Any other suggestions please?

Ta.

Adam

 

[SusanV]

Hi Shaker,

Are you using any linked tables? If so, you will need to reset the links via
tools>Linked table manager.

 

[The Shaker]

Hi SusanV,

No, there are no linked tables. Just a Main Form, with a subform inserted at
the bottom with linked Child and Master fields on Customer ID. Visual Basic
statement extracts records from Query with a button click (i.e. "On Click").
Valid records are returned to the Subform based on Customer ID.

Ta.

Adam

 

[SusanV]

some other things you can check:
On the "relocated" PC where you are having the trouble:
1. Verify that the query when run alone returns records
2. Verify whether the subform shows records when opened independently

 

[The Shaker]

Ta.

I'll need to go there to do this. Possibly in 48 hours.

Assuming:
1. Both work fine. What do I do now?
2. Neither works. Does not return records. What do I do now?


Ta.

Adam

 

[SusanV]

If the query returns no records, open it in design view to see whether any
of the fields are not being recognized - instead of seeing the field name,
it will say EXPRESSION or some such.

If the query returns records but the subform alone does not, check the
source of the subform is properly pointing to the query.

If the subform shows records when opened alone but not when embedded in the
main form, try removing it and reinserting it.

Best of luck - stinks that you have to travel to do this

=(

 

[SusanV]

Also verify that no references are listed as MISSING on the relocated PC -
this is the most likely cause as Maha stated.