D
Dennis
I think this is simple, but I am pulling my hair out trying to make this
work. I have a form associated with a table. I have an ID field which is my
key. I want to increment this field (80000) by one each time I add a new
record. I have an Add Record button on the form. On click I have a macro
that opens another table with only one record and only on field (80000). All
I want to do is read this, add one to it, move it to the Key field on the
form and write it back out to the table. I can get the tables to open and
records read, but when I try to add 1 to field I get a failure. Have not
even tried to move it to the key field yet. I sure would appreciate any help
..
Dennis
work. I have a form associated with a table. I have an ID field which is my
key. I want to increment this field (80000) by one each time I add a new
record. I have an Add Record button on the form. On click I have a macro
that opens another table with only one record and only on field (80000). All
I want to do is read this, add one to it, move it to the Key field on the
form and write it back out to the table. I can get the tables to open and
records read, but when I try to add 1 to field I get a failure. Have not
even tried to move it to the key field yet. I sure would appreciate any help
..
Dennis