Hiding Forms/retiring values

[Naia]

Two questions:

1) I have created a new form to replace an old form. However, I am a little nervous about deleting the old form. Is there a way I can hide it or move it so it doesn't confuse my data entry technicians (they are very easy to confuse).

2) I have a drop down list on a form which options are pulled from a table. I no longer want to be able to select ‘A’ from the drop down list but if I delete it from the table it deletes the option from all previous forms. I do not want to delete ‘A’ from previous forms, just disable it so it cannot be selected in the future.

Thanks, N

 

[pbaldy]

1) Personally I make changes to a copy of the db, then rename them when I want to put the changes in. In that scenario, you could simply delete the form. If you need it, it's still in the old version. It also sounds like you're letting users see/use the database window, which most of us don't do.

2) You can simply remove "A" if the combo is a value list. If it's a query, change the SQL to

SELECT FieldName
FROM TableName
WHERE FieldName <> "A"