I can't fill a required field in a record Add (before EndEdit)

  • Thread starter Thread starter Larry Woods
  • Start date Start date
L

Larry Woods

I have a required field in my db table. I am filling a table with a NEW row
via a form with bound textboxes. I get a particular required field ( a
foreign key) from another source. When I get ready to update my table I do
an "EndEdit" and it detects that I have not yet filled the required
field...and I error out. So I try to force the field value into the table
BEFORE the "EndEdit", referencing Row(0), but I error out with an error that
points out that I don't HAVE a Row(0) yet! So how do I fill in a required
field in a new record BEFORE I get to the EndEdit? I have been able to do
it with "0 x 0" textboxes, but this seems very bad form, right?

???????????

TIA,

Larry Woods
 
Do you have a DataRelation set up between them? If not that would probably
fix this problem. However assuming that you can't do that - set a default
value on the datacolumn - that will at least let you save - and then change
the value immediately after you have it.
 
Back
Top