How Do I Detect a New Record from the Navigation Buttons 
Author Message
 How Do I Detect a New Record from the Navigation Buttons

I'm having a problem in the OnCurrent event in detecting if a record has
been added from the Navigation Button -- the button with the asterisk-right
arrow[*>]. If I could detect if that button has been pressed, it would save
me a lot of headaches.

The reason:  my subform disables the text boxes if there is no "billNumber"
(in OnCurrent).  If the "new record" button in the navigation buttons is
pushed, the OnCurrent event disables all the text boxes and the user can't
add a record as needed.  The process is more complicated than described, but
the pertinent information seems to be stated.

I've tried the 'NewRecord' call, but it returns true both when the subform
is empty and when the 'new record' button is pushed.

Any suggestions would be appreciated!

Thanks-
ScottP



Tue, 23 Mar 2004 02:40:33 GMT  
 How Do I Detect a New Record from the Navigation Buttons
My advice: remove the navigation buttons! If they need the ability to
navigate from current to prior or next, create your own navigation buttons.
New records get added via a 'New' button.

Steve

Quote:
> I'm having a problem in the OnCurrent event in detecting if a record has
> been added from the Navigation Button -- the button with the
asterisk-right
> arrow[*>]. If I could detect if that button has been pressed, it would
save
> me a lot of headaches.

> The reason:  my subform disables the text boxes if there is no
"billNumber"
> (in OnCurrent).  If the "new record" button in the navigation buttons is
> pushed, the OnCurrent event disables all the text boxes and the user can't
> add a record as needed.  The process is more complicated than described,
but
> the pertinent information seems to be stated.

> I've tried the 'NewRecord' call, but it returns true both when the subform
> is empty and when the 'new record' button is pushed.

> Any suggestions would be appreciated!

> Thanks-
> ScottP



Tue, 23 Mar 2004 03:09:44 GMT  
 How Do I Detect a New Record from the Navigation Buttons
Thanks, I did it your way... (ok, so I'm Frank's antithesis today:^) I could
have wasted a lot of time trying to do it my way.

But still!!  -- there has to be some way to see if the Navigational button
"add new" was pushed.  Also, I've learned a good lesson about going to other
records in the OnCurrent event :^((

Anyway, I like my new homemade Nav buttons better than the built-in ones.
Your suggestion is much appreciated!

Thanks for your help--
ScottP


Quote:
> My advice: remove the navigation buttons! If they need the ability to
> navigate from current to prior or next, create your own navigation
buttons.
> New records get added via a 'New' button.

> Steve


> > I'm having a problem in the OnCurrent event in detecting if a record has
> > been added from the Navigation Button -- the button with the
> asterisk-right
> > arrow[*>]. If I could detect if that button has been pressed, it would
> save
> > me a lot of headaches.

> > The reason:  my subform disables the text boxes if there is no
> "billNumber"
> > (in OnCurrent).  If the "new record" button in the navigation buttons is
> > pushed, the OnCurrent event disables all the text boxes and the user
can't
> > add a record as needed.  The process is more complicated than described,
> but
> > the pertinent information seems to be stated.

> > I've tried the 'NewRecord' call, but it returns true both when the
subform
> > is empty and when the 'new record' button is pushed.

> > Any suggestions would be appreciated!

> > Thanks-
> > ScottP



Tue, 23 Mar 2004 06:52:24 GMT  
 How Do I Detect a New Record from the Navigation Buttons
Hi Scott,

Quote:
> But still!!  -- there has to be some way to see if the Navigational button
> "add new" was pushed.

Hmm, the BeforeInsert Event should get triggered regardless of the method
used to Add a new record. I like to control the process, rather than allow
multiple techniques.

Steve



Tue, 23 Mar 2004 21:39:39 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Detecting user changes a record on form with Navigation buttons

2. Navigation Buttons - Not Allowing New Record Creation with Next Record

3. how to add new record to a subform while disable navigation button

4. Form Navigation Button creating new record

5. New record navigation button disabled on subform with autonumber primary key

6. My navigation buttons dependent on Access navigation buttons?

7. Detect Min/Max/Close and Navigation Buttons?

8. capturing the record number and total records in a form with no navigation buttons

9. Is There any Form Event for moving from record to record when using Navigation button

10. detect record navigation


 
Powered by phpBB® Forum Software © phpBB Group