I want to keep the data saved, but not view it in the form

[ljjtek]

Been outta the "Access" loop for a while so this might be a really simple and obvious answer. Basically, I have my DB to track events etc. I use the switchboard and have an "Enter/View Events" option. If the event has passed I would rather not see the record for that event to come up when I view the events, but I don't want to erase that event or any records associated with it. Would this be something that I would use the "events" form/table to customize the option? Or the switchboard? I just don't want to see 100 events come up in the view which I have to then scroll through to see the upcoming ones. Is there a sort option I would also use? Again, been outta the loop and need HELP!
Thanks

 

[LittleSmudge]

Two options come to mind.

In the table that holds the event data do you have a field that holds the event date ?
If yes then
option A
Else
option B
End IF

option A
Change the RecordSource of your form to something like
"SELECT * FROM tblEvents WHERE EventDate > #" & Date() & "#"


option B
Add a field to the table containing the Event data called Finished or type Boolean, Default value False

When an event is over set Finished to True
Change the RecordSource of your form to something like
"SELECT * FROM tblEvents WHERE Finished = False"


option B will even allow you to hide a cancelled event before it's due date if required.


'ope-that-'elps.



G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

 

[ljjtek]

I must be really, really, out of the loop cause I'm drawing a total blank.... Now I can't even remember how to find what table or query I'm using as my form source! It has a subform too....I'm just totally confused. If you have any tips other than to bang my head against the wall, which is pretty much what I'm about to do, then let me know! Otherwise, thanks anyway, I'm just too out of it today!

 

[LittleSmudge]

Form in design mode

Click on Properties tool in tool bar to view Properties dialog box

Select Form as active object ( click little grey box top left of form )

First row in property box = Record Source

QED.


G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.