Charlotte Foust
cfoust at infostatsystems.com
Fri Oct 14 15:25:16 CDT 2005
Now I'm thoroughly confused. You asked if there was any way to identify whether the current record is the last record ... On the page? Then you say the last record is the patient's current record. Do you mean the patient's record for the current date, but not necessarily the record that has the current focus? Can't you just check to see if the date = the current date and set allowedits based on that condition? I'm not sure I understand why the user could edit a previous date's records but not the current date's records though. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lonnie Johnson Sent: Friday, October 14, 2005 12:54 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Last Record of a Continuous Form Last on the page. The recordsource is in date order. It is the history of activity for patients. I do not want the last record (which is the patient's current record) to be altered from this page. I used the... If Me.CurrentRecord = Me.RecordsetClone.RecordCount Then ...lock it down Else ...let me do it End If Charlotte Foust <cfoust at infostatsystems.com> wrote: Define "last" record: last in the recordset, last on the page, latest entered, the one above the add row ....? Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lonnie Johnson Sent: Friday, October 14, 2005 9:15 AM To: Access Developers discussion and problem solving Subject: [AccessD] Last Record of a Continuous Form Is there anyway to indentify if the current record is the last record in a continuos form? May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Yahoo! Music Unlimited - Access over 1 million songs. Try it free. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Yahoo! Music Unlimited - Access over 1 million songs. Try it free. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com