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

Subform - was working; edited design; not working

P: n/a
In my database, I have a form with a subform. I had everything working
correctly - the correct records would display on the subform for each
record on the form. I could edit, add, and delete on the subform.

I added a field to my table, and modified the design of my subform. Now,
data is not getting displayed on the subform for any form records. I did
not change any properties.

I'm on XP Pro and using MS Office 2000 Pro.

Thanks for any help you can give me.

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Scott wrote:
In my database, I have a form with a subform. I had everything working
correctly - the correct records would display on the subform for each
record on the form. I could edit, add, and delete on the subform.

I added a field to my table, and modified the design of my subform. Now,
data is not getting displayed on the subform for any form records. I did
not change any properties.

I'm on XP Pro and using MS Office 2000 Pro.

Thanks for any help you can give me.

Is the form build on a table or query? If query, is there the
possibility a relation was reset or deleted...example an inner join
pointing to the wrong field in the table to be related?

Can you open the subform by itself and display records?

Did the properties change on the link? Click on the subform area when
modifiying the main form in design mode and pull up the property sheet
and check the Master and Child links. Are they correct?

Is it possible all of the data in the child table is gone.

Lastly, reboot.

Nov 12 '05 #2

P: n/a
I was not able to display the subform by itself with the data, so I then
ruled out it being a link problem. But, I had checked my link properties and
those looked correct. The data from the table still existed. Rebooting did
not fix it.

I was finally able to figure it out and I had the data entry property set to
yes.

Thanks for your help.

"Salad" <oi*@vinegar.com> wrote in message
news:yr******************@newsread1.news.pas.earth link.net...
Scott wrote:
In my database, I have a form with a subform. I had everything working
correctly - the correct records would display on the subform for each
record on the form. I could edit, add, and delete on the subform.

I added a field to my table, and modified the design of my subform. Now,
data is not getting displayed on the subform for any form records. I did
not change any properties.

I'm on XP Pro and using MS Office 2000 Pro.

Thanks for any help you can give me.

Is the form build on a table or query? If query, is there the
possibility a relation was reset or deleted...example an inner join
pointing to the wrong field in the table to be related?

Can you open the subform by itself and display records?

Did the properties change on the link? Click on the subform area when
modifiying the main form in design mode and pull up the property sheet
and check the Master and Child links. Are they correct?

Is it possible all of the data in the child table is gone.

Lastly, reboot.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.