Subdatasgett and Query Message

[Guest]

When I add a data record thru a query subdatasheet and exit the outermost
query, I get a message asking if I want to replace the query. Why does that
happen? I have not modified the query. Thanks.

 

[John Vinson]

When I add a data record thru a query subdatasheet and exit the outermost
query, I get a message asking if I want to replace the query. Why does that
happen? I have not modified the query. Thanks.

You may want to consider using a simple Form with a Subform.
Table/query datasheets are not really designed or intended for data
entry or updating. I really don't know why you're getting the prompt,
since I routinely turn off all subdatasheets - they're a major drag on
performance.

John W. Vinson[MVP]