[AccessD] Update or Cancel Update without Addnew or Edit

...lol ...redesign the form to have a single data source ...I've seen this 
happen when a subform is bound to a different query based on the same 
table/query as the main form record source ...if one is dirty, an update to 
the other can give you strange feedback depending on your cb.

William

--------------------------------------------------
From: "Rocky Smolin" <rockysmolin at bchacc.com>
Sent: Monday, June 08, 2009 11:04 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Update or Cancel Update without Addnew or Edit

> Possible.  Work-around?
>
> Rocky
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
> Sent: Monday, June 08, 2009 5:57 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Update or Cancel Update without Addnew or Edit
>
> ...sub-query/form hitting the same record as the main?
>
> William
>
> --------------------------------------------------
> From: "Rocky Smolin" <rockysmolin at bchacc.com>
> Sent: Monday, June 08, 2009 7:04 PM
> To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
> Subject: [AccessD] Update or Cancel Update without Addnew or Edit
>
>> Dear List:
>>
>> I am getting a mysterious message in a client app "Update or Cancel
>> Update without Addnew or Edit", mysterious because, first there's no
>> Debug button so I can't see where it's happening, second, it's a bound
>> form - no DAO, no recordsets, no Update or Cancel Update instructions
>> in the code, third, it's not reproducible, but it happens enough that
>> I've got to figure out what's causing it.
>>
>> I have a feeling the error message is not telling me what the real
>> error is
>> - like the one that says "you cancelled the previous operation" which
>> I didn't but it usually means there's a problem in the SQL that being 
>> run.
>>
>> Anyway, anything at this point would be welcome.  It's a stumper.
>>
>>
>>
>> MTIA
>>
>>
>>
>> Rocky Smolin
>>
>> Beach Access Software
>>
>> 858-259-4334
>>
>> www.e-z-mrp.com <http://www.e-z-mrp.com/>
>>
>> www.bchacc.com <http://www.bchacc.com/>
>>
>>
>>
>>
>>
>>
>
>
>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>