A
Amir
HI!
I have two problems with the Ctrl+' keyboard shortcut I would be grateful if
you help me to solve:
1. In some cases after I use that shortcut, Access copies the value from the
previous record, but when I finish editing the new record with the copied
values, I get an error message for some of the required fields, just as if I
left them empty (It doesn't happen if I fill these fields myself, only if I
use the Ctrl+' shortcut).
2. In other cases (in different form), when I'm trying to use this shortcut,
as I press the key combination I get the following error message:
The field 'tblDeliveryPagesData.DeliveryPageSupplier' cannot contain a null
value because the Required property for this field is set to True. Enter
value in this field.
This is weird because the combobox which has the value for this field does
not look empty (because i've just pressed Ctrl+', and the value from the
previous record was copied to the current record (The previous record does
have value in that field, so it didn't copy 'null' or something..)).
The two problems seem to have connection to each other. It seems like access
copies the value only to the VIEW of the form, but doesn't change the value
itself. It's kind of weird because in other controls it works just fine..
I will be grateful if you could help me with that..
Kind Regards,
Amir.
I have two problems with the Ctrl+' keyboard shortcut I would be grateful if
you help me to solve:
1. In some cases after I use that shortcut, Access copies the value from the
previous record, but when I finish editing the new record with the copied
values, I get an error message for some of the required fields, just as if I
left them empty (It doesn't happen if I fill these fields myself, only if I
use the Ctrl+' shortcut).
2. In other cases (in different form), when I'm trying to use this shortcut,
as I press the key combination I get the following error message:
The field 'tblDeliveryPagesData.DeliveryPageSupplier' cannot contain a null
value because the Required property for this field is set to True. Enter
value in this field.
This is weird because the combobox which has the value for this field does
not look empty (because i've just pressed Ctrl+', and the value from the
previous record was copied to the current record (The previous record does
have value in that field, so it didn't copy 'null' or something..)).
The two problems seem to have connection to each other. It seems like access
copies the value only to the VIEW of the form, but doesn't change the value
itself. It's kind of weird because in other controls it works just fine..
I will be grateful if you could help me with that..
Kind Regards,
Amir.