How to update records displayed after delete-sw set by user

[kronar30]

I use a subform based on a query to display records not yet deleted. One of the fields in the records is the delete-sw. How do I requery the records after user sets one of the records delete-sw (so that record no longer shows)?

 

[TheAceMan1]

How are ya kronar30 . . .

Do you want to atually delete the record or just not include it in the recordset? ... Is there some proprietary rule that takes precedence?

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[kronar30]

Setting the delete-sw does delete the record in the table, but I dont know how to requery for the subform displayed.

 

[Andrzejek]

How do you query it now?
Do you have delete-sw field in your query? Something like:
[tt]
SELECT * FROM MyTable
WHERE delete-sw <> 'Y'[/tt]

Have fun.

---- Andy

 

[TheAceMan1]

[blue] ... I dont know how to requery for the subform[/blue][/code]
If your code is running in the mainform:

[blue]   [subFormName].Form.Requery[/blue]

If your code is running in the subform:

[blue]   Me.Requery[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]