By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,214 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Form Blank Please Help

100+
P: 164
I am sort of in a panic here, I had just finished up a database and decided to do a little polishing up. I went into a form with a subform and decided to add another field to the main part of the form from a table it was pulling from in the first place. When I drug the field (memo field) from the add existing fields window, it asked to link the fields from the table to the form, and like an idiot, I thought I knew what I was doing, I just linked it the "CustomerName" field on my form and I went to view it form view and NOTHING is there.

In design view everything is still there. I quickly DELETED that field that I added hoping it would fix the problem, and sadly it didnt.

Somebody PLEASE tell me they have made this same mistake before and hopefully you could tell me how to fix this!

*fingers crossed*

THANK YOU
-Mike
Feb 1 '08 #1
Share this Question
Share on Google+
2 Replies


puppydogbuddy
Expert 100+
P: 1,923
I am sort of in a panic here, I had just finished up a database and decided to do a little polishing up. I went into a form with a subform and decided to add another field to the main part of the form from a table it was pulling from in the first place. When I drug the field (memo field) from the add existing fields window, it asked to link the fields from the table to the form, and like an idiot, I thought I knew what I was doing, I just linked it the "CustomerName" field on my form and I went to view it form view and NOTHING is there.

In design view everything is still there. I quickly DELETED that field that I added hoping it would fix the problem, and sadly it didnt.

Somebody PLEASE tell me they have made this same mistake before and hopefully you could tell me how to fix this!

*fingers crossed*

THANK YOU
-Mike
Mike,
It sounds like you changed the Master/Child links between the main form and the subform. All you need to do is restablish the links to what they were. To re-establish the links go to the subform control (click on the border between the main form and the subform), go to the master link property and click the build button and select the correct master link. Then do the same for the child link, then save and you should be good to go. Incidentally, this is why you need to have backup copies of your database when you make changes. Be sure you have a backup copy in the future.
Feb 1 '08 #2

100+
P: 164
Mike,
It sounds like you changed the Master/Child links between the main form and the subform. All you need to do is restablish the links to what they were. To re-establish the links go to the subform control (click on the border between the main form and the subform), go to the master link property and click the build button and select the correct master link. Then do the same for the child link, then save and you should be good to go. Incidentally, this is why you need to have backup copies of your database when you make changes. Be sure you have a backup copy in the future.
NOTE taken! and your advice worked perfectly. I was flipping out there for moment. I usually do backups quite often, but I think I got to carried away with this one tonight and didn't bother being smart. THATTL teach me.

Thank you so much!
Feb 1 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.