Lonnie Johnson
prodevmg at yahoo.com
Sat Oct 15 08:35:58 CDT 2005
The patients are actually children being placed in different foster homes. Each time a child is moved from one home to another or goes awol or goes to the hospital, a "placement record" is appended to table. Some kids move so much that errors occur in data entry. We have a special form that shows this history. This form shows the history in chronological order. The last record listed on the page in the continuous form indicates the most recent movement or the current placement of the child. That cannot be edited. It is changable at the master record level. This is one of those cases where the "business practice" of the company dictates the development of the object. At any rate, David McAfee seemed to know what I needed and with that I was able to do exactly what the requestor wanted. Charlotte Foust <cfoust at infostatsystems.com> wrote: 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 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 -- 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.