J
JohnG
I have created a main form in which I have placed a Tab
control. The Tab control has two tabs (Custumers and
Contacts). Inside the Custumers tab I have placed a Sub
form which is sourced directly from the Customers table.
I have palced Two navigation buttons on the customers tab
control (back and next) which work fine for navigating
the subform. I have also added an Add new command button
on the bottom of the tab control which seemingly work
fine as it calls up a new blank record set ready for data
entry.
The problem is that when I start to enter data into one
of the fields I get a VBInformation Message box with the
following information:
" You Can't assign a value to this Object."
* The object may be a control on a read only form
* The Object may on a form that is opened in design view
* The value maybe too large for this field
after clicking the ok button of the this info box I can
now enter the data, but when I've completed entering the
record and saved it, if I navigate back through the
record set the new entry disapears form the record set.
Only when I close the mian form and reopen it does my new
record appears.
can any one please explain what is going on here
I have checked and both the main form and the sub form
have been set to allow both edits and additions
Thanks in advance JohnG
control. The Tab control has two tabs (Custumers and
Contacts). Inside the Custumers tab I have placed a Sub
form which is sourced directly from the Customers table.
I have palced Two navigation buttons on the customers tab
control (back and next) which work fine for navigating
the subform. I have also added an Add new command button
on the bottom of the tab control which seemingly work
fine as it calls up a new blank record set ready for data
entry.
The problem is that when I start to enter data into one
of the fields I get a VBInformation Message box with the
following information:
" You Can't assign a value to this Object."
* The object may be a control on a read only form
* The Object may on a form that is opened in design view
* The value maybe too large for this field
after clicking the ok button of the this info box I can
now enter the data, but when I've completed entering the
record and saved it, if I navigate back through the
record set the new entry disapears form the record set.
Only when I close the mian form and reopen it does my new
record appears.
can any one please explain what is going on here
I have checked and both the main form and the sub form
have been set to allow both edits and additions
Thanks in advance JohnG