Subforms disappear

[tsonnenl]

Hi-
I have a subform that deletes the data typed into it when I do something like print or print preview. The resulting printout does not include the now empty subform. What might cause this data to disappear? Any ideas?

Thanks in advance.
Todd

 

[WildHare]

Why is the data being deleted? You need to check the code behind this subform and find what's deleting records.

There are two ways to argue with a woman - neither one works.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[tsonnenl]

I share your frustration in the lack of info. I'm cleaning up a database made by someone in a rush and working with Access for the very first time. This form has no code behind it and is linked to an uncomplicated table. I was hoping that there was some subform property that commonly caused this error.

Todd

 

[WildHare]

The subform should be backed by a query (in the best case) or a table. Check to make sure the query returns records. Normally, typing info in to form fields should not trigger a delete action, but you never know what other programmers are gonna do..

Jim There are two ways to argue with a woman - neither one works.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[legalkill]

Check the link of the subform. The data may be loosing a linked value that defines how it links to the main data. Properties child/master. Fix by making sure the subform is linked to a main data value (like an ID)

 

[tsonnenl]

Thanks. I realized that I wasn't getting the correct properties when I clicked on the square in the upper left corner of the subform. Eventually found the linking error.

As usual, just had to step away from the problem to find the solution.