specific record

[thewabit]

Is it possible to have a message or a flag of somesort pop up when a specific numbered record is entered? Say I want something to happen after record # 10 is entered.

thanks

[RuralGuy]

Do you know how to determine how many records are in your RecordSet?

[thewabit]

Other than opening up the table alot...no.

[RuralGuy]

If you are talking about entering records by opening the table directly, then the answer is *no*. There are no triggers in Access tables. You can however do what you suggest by entering your records through a form.

[thewabit]

Yes..I am suggesting through a form. Can a form keep track and "flag" memon a specified record number?

[RuralGuy]

If you do a .Movelast in the RecordsetClone, the RecordsetClone.RecordCount will tell you how many records are in the Recordset.

[MAF4Fam6]

Is it possible to have a message or a flag of some sort pop up when a specific numbered record is entered? Say I want something to happen after record # 10 is entered.

thanks

Just curious if you were able to resolve your issue.

If you are still looking/working on a solution, can you elaborate further on your above quote?
I don't quite understand what you are checking (i.e. field's value, AutoNumber, record count in Recordset) against (i.e. LIST of predetermined Record numbers, every 10th record in Recordset, etc).

Thanks.

-RC

[thewabit]

I got some real good ideas from some folks but I don't know if the issue is resolved because I haven't gone "live" with the database yet. When I find out if there suggestions worked or didn't work, I will let you know.

thanks for checking!

Cheers

[MAF4Fam6]

No problem...take care!

-RC