Hdr with detail records, auto record advance

[dcavaiani]

When I am entering records into the detail sub file, and I fill in the final entry field for a NEW detail record, how do I get the form to ADVANCE to the next entry line. Right now, it only shows the "dirty" indicator on the line I have just entered, and I have to reclick on the dirty indicator to get the record saved and the form advanced to the next open data entry line.

 

[pbaldy]

What is the Cycle property of the detail form?

 

[dcavaiani]

All Records

 

[pbaldy]

Oh, and what's the Enter Key Behavior for the last textbox in the tab order?

 

[dcavaiani]

default .....

 

[pbaldy]

Those sound appropriate. Can you attach the db here?

 

[dcavaiani]

Will do. After I enter the Unit price (macro is "entries/update to Materials table", the cursor actually jumps backwards to the taxable field ? vba may need cleanup? I was also concerned that Delete a detail record was not recomputing properly?

 

[pbaldy]

Well, first thing to address is the tab order. It should be the order you want the cursor to follow. Taxable is after unit price.