incrementing a field value for new record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi there

I have form where a series of tests are entered. Each test has a row and plate. What i want to occur is this

1 user enters first test: row 1, plate
2 user clicks next tes
3 values of first test are saved to tabl
4 new test is created
5 plate is incremented to
process is repeated for next test

How can i do this?
 
Forms display data and allow users to enter/modify it; Tables actually store
the data in Records. How are you _storing_ the tests, rows, and plates? That
will make a difference in the answer.

For good suggestions on effective use of newsgroups, visit the FAQ at
http://www.mvps.org/access/netiquette.htm.

Larry Linson
Microsoft Access MVP

Carlee said:
hi there,

I have form where a series of tests are entered. Each test has a row and
plate. What i want to occur is this:
 
Back
Top