By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,231 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
swingingming wrote:
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


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
Nov 13 '05 #2

P: n/a
swingingming wrote:
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


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
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.