default number from 2nd record

S

Song Su

I have a frmPO with subform frmPODetail to track Purchase Order. It's one to
many relationship (one PO can have one or more items in PODetail).

When user enter record in subform, in Tag field (number type), if user type
1001 in the first record, how can I give 1002 on the second record as
default if that PO has more than one items?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

previous record+1 as default 4
copy a record and add a revision number 5
Subform w/defaults from main form 9
Record sum from subform 1
Auto-Line-Numbering 1
Set Controls Default Value from another Control 4
Excel Excel: Match, Index and subtract across 2 columns and 2 tabs 2
Determine subform total before code runs 2

Top