[AccessD] Updatable UNION?

Hi Andy
How are things??
Say Hello to your lovely for me

In cases like this in the on_click of a check box
I just look at its current value. 
Then run a query based on the opposite value then refresh or Requery the
screen

Eg 
If Me.chkCheckBox = -1 then
	docmd.openquery "upd_qryThatChangesTheValueForThisRecordToZero
ElseIf Me.chkCheckBox = 0 then
	docmd.openquery "upd_qryThatChangesTheValueForThisRecordToMinus1
End if

Me.requery

And if needed set a bookmark or global so you can return to the
Relavant record after a requery

Hope this helps

And we'll see you.........:-)))

DD

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: Thursday, 18 November 2004 9:50 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Updatable UNION?

Feared that might be the case. Ah well, always worth asking the list cos if
there's a way someone here will know it. Thanks for the response Gustav.
--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
To: accessd at databaseadvisors.com <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Updatable UNION?
Date: 18/11/04 10:59

>
> Hi Andy
>
> No, unions are read-only. If you can't go the update-behind-requery 
> route, I guess you are left with the temp table.
>
> /gustav
>
> >>> andy at minstersystems.co.uk 18-11-2004 10:09:56 
> >>>
>
> Morning all
> I've a continuous screen which needs to list two types of order in 
> date sequence. These are held on separate tables. No problem, a UNION 
> query does the job fine. However the user has to tick an order to say 
> it's despatched, and then the screen needs to show that information, 
> but the recordset is not updatable. Presumably this applies to all 
> UNION queries does it? Does anyone have a way round this or do I have 
> to go to extracting to a temp table and all that jazz?
>
> By the way it's not practical to upodate the underlying tables and 
> requery to display the depatch info because there's a lot of data on 
> screen and requerying takes too long.
>
> --
> Andy Lacey
> http://www.minstersystems.co.uk
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
>

________________________________________________
Message sent using UebiMiau 2.7.2

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com