I have a form that has the record source set to a table named "dogs database". It has always worked until now. I have passed the database to a friend to do her input for her dog show and she wanted some changes made so zipped the db and sent it back to me. When I open the form there are no records to be seen - however all the records (5506 of them) can be seen in the table. I tried attached it so someone could have a look and see why I can't get the form to recognise the record source, but the file won't load . If someone would like to offer their services I'll email it to them.
Even if I try putting a new field on the form it doesn't work. I'm pulling my hair out at the moment!!!!!! PLEASE HELP if you can.
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
File received. What you need to do is turn off "Data Entry".
In the form's properties, find the Data Entry property and set it to No. Despite it's strange name, the property makes the form only able to do data entry and not view any existing data. Once you set that to No, all your records will be accessible again.