From: AYHAN MUSLU PC on

"Amelia" <Amelia(a)discussions.microsoft.com>, iletisinde şunu yazdı,
news:107301AF-FF03-4708-81E4-006A13761B6D(a)microsoft.com...
> First, can you use IIF with a checkbox?
>
> What I want to do is if the checkbox is marked(item is sold), then after
> update (checkmark is checked) I want it to append that item to a new table
> and open the form that goes with the table and if it is not done then do
> nothing (null?).
>
> So do I need to create an append query and then have it open the query?
>
> What it is is if an item is sold at auction, I want to check that the item
> is sold and then move that item to a sold item table that has more
> information about the sale.
>
> Any help would be great!