Not I have tried this in bot 2000 and 2003

Problem: I have a form with a subform they are a sales order and the sub form is the orderline item. There is a 1 to many relationship between sales and orderline. The form/subform only displays 1 sales order and 1 order line item at a time. I want to do the following: I want several dates and text fields on the orderline to default to the value of the previous orderline of the order. Example create order 1 line 1 enter po# as 12345 enter date scheduled as 11/1/05 when i add the orderline and go on to the next line item i want the po and date scheduled for line 2 to default to the value of the line just added so if i change them on line 2 line, 3 values for these fields default to line 2 values.

I am tryng to set the default value propoerty of at the form level before going to the new line via
Forms!sales!orderline!Po.DefaultValue = Me!Po.Value but all i get is #name ? when i go to next record

what am i missing

Thanks

Hi
Welcome to Utter Access Forums

Check out:
How to fill record with data from previous record automatically in Access 2000.
also
Referring to a Field in the Previous Record or Next Record.
HTH's