|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 22nd, 2005, 02:15 AM
|
|||
|
|||
new or existing record
IF the pointer is on a record (field) that is part of a newrecord (ie adding
a new record) rather than on an existing record, how can I test for this, so that double clicking the field if the record already exists will not work, but only work within the field if the I am adding a new record at the time. hope that makes sense -- Regards Patrick Stubbin 
|
|
#2
August 22nd, 2005, 02:34 AM
|
|||
|
|||
|
"Patrick Stubbin" wrote in message
IF the pointer is on a record (field) that is part of a newrecord (ie adding a new record) rather than on an existing record, how can I test for this, so that double clicking the field if the record already exists will not work, but only work within the field if the I am adding a new record at the time. hope that makes sense If this is on a form, the form's NewRecord property is true if you are on a new record that has not yet been saved. Once you save the record, though, it's not "new" any more. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)
|
|
#3
August 22nd, 2005, 02:45 AM
|
|||
|
|||
|
thanks, will use that
-- Regards Patrick Stubbin "Dirk Goldgar" wrote: "Patrick Stubbin" wrote in message IF the pointer is on a record (field) that is part of a newrecord (ie adding a new record) rather than on an existing record, how can I test for this, so that double clicking the field if the record already exists will not work, but only work within the field if the I am adding a new record at the time. hope that makes sense If this is on a form, the form's NewRecord property is true if you are on a new record that has not yet been saved. Once you save the record, though, it's not "new" any more. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| User Saving a Record else it deletes | Carter Wexler | Using Forms | 1 | August 2nd, 2005 11:57 PM |
| Inspect record, replace null field on output | RNUSZ@OKDPS | Setting Up & Running Reports | 3 | April 5th, 2005 04:27 PM |
| Gaps in Form "Record Number Boxes" | EricRod | New Users | 5 | March 5th, 2005 02:01 AM |
| dealing with a subform record when it's "dirty" | Paul James | Using Forms | 8 | October 17th, 2004 08:45 AM |
| Extracting elements from existing record to a new record | Mark W | General Discussion | 1 | September 28th, 2004 11:47 AM |
Linear Mode
