keeping deactivated items in previous records. Checkbox question..

[mhummel]

Hi



In a table (tblItem) I have these fields. ItemID, ItemName, ItemCategory, Checkboxfield: ItemInactivated

I want to create a form where I want to enter records from the tblItem via a combobox from where I can choose only active items.

Should an item be inactive I don't want it to show in the combobox. Still they have to remain in the previous records I made.

I have tried, but...

Can anyone help me on this subject?

I am a novice on this field (Access) however I have basic knowledge

I appreciate any help thank you.

[pbaldy]

Try a row source of:

SELECT * FROM tblItem WHERE ItemInactivated = False

[mhummel]

Hi Paul
Thanks for your reply.

I have tried your row source - It leaves me where I was before though...

Lets say I have entered Item1 in record1 in form and Item2 in record2 etc. When I check Item1 inactive in tblItem it vanish from the record1. I would like to be able to make Item1 inactive for the coming records, but still keep record1 intact.. How do I keep Item1 in record1 even when it's checked inactive?

Thanks a lot for your help

[Missinglinq]

Your Combobox needs to be Unbound (i.e. have no Control Source) with the selection made assigned, using the AfterUpdate event of the Combobox, to a Textbox, which is Bound to the Field in the underlying Table.

By doing this the previously selected, but now inactive element, will still be displayed in old Records, while the cbo will only display active elements.

Linq ;0)>