Tech

peispud

<div>
Thank you for your prompt answer. &nbsp;It's much easier to go down the correct road the first time. You helped me do that.<br />
This saves a lot of needless work to correct this later.
</div>


<div>
<div class="content wysiwyg-content">
Hi.<br />
<br />
Using continuous form --- Microsoft Access database. <br />
<br />
My database has thousands of product records. &nbsp;Some of these products are archived from time to time. &nbsp;<br />
For those records [Archived] = True, &nbsp; [Archive Date] &nbsp;will be updated.<br />
<br />
My question is about best practices.<br />
<br />
1) &nbsp;Should I move the records to another table? &nbsp; <u> If yes, then my question ends here.</u><br />
<br />
If no, &nbsp;then &nbsp;what is &quot;best practice&quot; in dealing with the visibility of those archived records? <br />
When the user is doing searches on the records, &nbsp;I prefer that the results would never show those records where [Archived] &nbsp;= True. &nbsp;(unless &nbsp;checkbox_IncludeArchives = true)<br />
<br />
Currently, the record source for the form is a table. &nbsp; So, should my<br />
<br />
1) application automatically ensure &nbsp;Me.FilterOn = True (at all times) &nbsp;and modify Me.Filter (when user does a search) &nbsp;to reject the archived data &nbsp; (when checkbox_IncludeArchives = false)<br />
<br />
2) application change record source to a query when checkbox_IncludeArchives = true<br />
<br />
3) a better way?
</div>
</div>


Hi.

Using continuous form --- Microsoft Access database. 

My database has thousands of product records.  Some of these products are archived from time to time.  
For those records [Archived] = True,   [Archive Date]  will be updated.

My question is about best practices.

1)  Should I move the records to another table?    If yes, then my question ends here.

If no,  then  what is "best practice" in dealing with the visibility of those archived records? 
When the user is doing searches on the records,  I prefer that the results would never show those records where [Archived]  = True.  (unless  checkbox_IncludeArchives = true)

Currently, the record source for the form is a table.   So, should my

1) application automatically ensure  Me.FilterOn = True (at all times)  and modify Me.Filter (when user does a search)  to reject the archived data   (when checkbox_IncludeArchives = false)

2) application change record source to a query when checkbox_IncludeArchives = true

3) a better way?

Best practices when dealing with archived (not yet deleted) records

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.