Major disaster!

[Bob500]

Uh oh!

I have a huge problem, I was tinkering around with events on one of my subforms when somehow it's record source got changed. I changed it back but now no data appears, even though I know that everything is linked and named correctly?

Any ideas? I can email the files if anyone can take a look but they are 16mb


Heeeeeelp !

 

[KenReay]

Hi

Messing up the link fields could cuase this try - Checkout the link fields property of the subform control on the main form, enure it is correct

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Bob500]

I have checked that and it is fine.

I should mention that I am using linked tables, and I have tried creating a new form using form wizard based on information from these linked tables and it does the same, no data and no records!!!

What have I done

 

[RiazKhanmohamed]

you may find it easier to drop the links and recreate them. it tends to help. otherwise there should be an option somewhere to refresh links, which may sort this out.

 

[Bob500]

Phew! I think that I got it sorted.

Thanks Guys

 

[Eupher]

Anytime I start to tinker with a database, I make a backup copy of it first. You just never know what can go wrong.

Ken S.