Populate field...Next value

[KingRudeDog]

okay guys, this is more of a vba question.

I have a textbox [txtRequestNumber] on a form which is anchored to a table from which it pulls the data. After the primary key, this is the main record tracer of my db.

What is the sytax, so that when the form [frmMainForm] is opened to a new record (on open) so that Access grabs the last [RequestNumber] from that table [tblTestRequest] and adds 1 to it.......so that users don't have to write it in themselves, but it auto generates.

a [n = n+1] type thing.

I love my dog. My wife is jealous.

 

[boblarson]

check out the DMAX function. Also, if you use the search function here, there are a lot of posts with the same question you had.