how to disable the 'next' navigation button to new records on conditions?

how to disable the 'next' navigation button to new records on conditions?

Post by swingingmi » Sun, 17 Jul 2005 17:02:05


Hi, I am new here. And this is so confusing to me.

On the online MS access downloads, I downloaded the order entry sample
database. On the 'Orders by customers' form, we can click on the
'Payments' button and view/add new payments.

When the customer's 'amount due' is zero, the 'next record' on
navigation button is disabled. How does this work?

I tried my own, and the zero amount kept going on, until i opened the
form a second time.

I checked the form property, all the VBA codes for this form, and the
"Orders by Customers" form's subform's events. I could not find
anything.

What am i missing here?

Many thanks in advance.

ming
 
 
 

how to disable the 'next' navigation button to new records on conditions?

Post by Sala » Mon, 18 Jul 2005 11:58:20


Check for something like
AllowAdditions
in code (if it uses macros, good luck). It might be set in the form's
Before/After update code/macro. Ex:
If Me.AmtDue = 0 then me.allowadditions = False