Y
yanez
Hi to all NG members
Sorry for my English...
I've a small DB of customers who buy several items and pay for them in
several instalments.
I've a main form with pages and subforms in the pages.
I insert/select a customer in the first page then I go to a page where there
is a subform called "payments", where I select a specified item and
conseguently access shows in a sub-subform, called payments_sbf, all the
instalments payd for that item, here I can insert new payments.
There are customers in DB who haven't buyed anything: being each payment
relative to the couple customer-item, it shouldn't be possible insert a new
payment in that case.
In that case both the subform and the sub sub form are empty, better, rows
and controls of forms aren't displayed at all. (Do they exist? Do they have
null value?)
I set payments_sbf not to allow addition, and enable that via button and
VBA code. Clicking on this button Access gives the operator the possibility
to insert a new payment, still raising an error, when values are entered
since it misses the field, id_item_customer, that relates customers to items
and is a required field for the payment table.
I'm trying to detect this situation on some events, current, activate
gotfocus... of the payment form or payment_sbf with the aim to prevent the
operator fails in data entering.
The problem is it seems none of those events happen moving through customers
or items: at the moment I'm just tryng with msgbox...no message is shown.
Any suggestion?
thx
yanez
Sorry for my English...
I've a small DB of customers who buy several items and pay for them in
several instalments.
I've a main form with pages and subforms in the pages.
I insert/select a customer in the first page then I go to a page where there
is a subform called "payments", where I select a specified item and
conseguently access shows in a sub-subform, called payments_sbf, all the
instalments payd for that item, here I can insert new payments.
There are customers in DB who haven't buyed anything: being each payment
relative to the couple customer-item, it shouldn't be possible insert a new
payment in that case.
In that case both the subform and the sub sub form are empty, better, rows
and controls of forms aren't displayed at all. (Do they exist? Do they have
null value?)
I set payments_sbf not to allow addition, and enable that via button and
VBA code. Clicking on this button Access gives the operator the possibility
to insert a new payment, still raising an error, when values are entered
since it misses the field, id_item_customer, that relates customers to items
and is a required field for the payment table.
I'm trying to detect this situation on some events, current, activate
gotfocus... of the payment form or payment_sbf with the aim to prevent the
operator fails in data entering.
The problem is it seems none of those events happen moving through customers
or items: at the moment I'm just tryng with msgbox...no message is shown.
Any suggestion?
thx
yanez