How to roll off a record

[Noreene Patrick]

How do I "roll off " a record when I have finished filling the entire record?

I have a form that is continuous..the record is complete when I check a checkbox(Putaway) and fill out time ended(timePE). (Of course, there are several more records beneath that are not complete). I want that record to roll out of sight when those two items are complete.

If Me.Putaway.Value = True And Me.TimePE.Value > 0 Then
I am lost after that.


Thanks in advance, Noreene

 

[pbaldy]

Well, if by changing those values the record would no longer be selected by the form's query/filter/whatever, then requerying the form should drop the record.

 

[boblarson]

Also, on a continous form, if you don't want to see the "new" record below until you actually want to start one, make sure none of your fields have defaults set.

 

[Noreene Patrick]

I do want to see all the records that are not complete because they are continuously adding and updating records.

If me.putaway.value = true and me.timepe.value >0 then
me.requery?

I cant seem to figure out the syntax.

Sorry, I am at a loss

 

[Noreene Patrick]

Hey thanks guys,

I figured it out..made a query with timepe is null as criteria and used query to open form.

DUH!!!