Name Field

[Guest]

On my form I have one row of information I fill in.
Date, Man Number ( Select From Combo Box ),
Last Name ( Fills In Automatically from Combo Selection ) Tools Received -
Etc.

After the row is filled in a new row pops up under it to start next entry.

What I would like is to have the next row's "Last Name" field automatically
fill in based on the previous rows "Last Name" entry as a default and I would
change if need be.

Thanks

 

[Chris Reveille]

You could like at
ACC2000: Referring to a Field in the Previous Record or
Next Record at:

http://support.microsoft.com/default.aspx?scid=kb;en-us;210504&Product=acc2000

Chris

 

[fredg]

On my form I have one row of information I fill in.
Date, Man Number ( Select From Combo Box ),
Last Name ( Fills In Automatically from Combo Selection ) Tools Received -
Etc.

After the row is filled in a new row pops up under it to start next entry.

What I would like is to have the next row's "Last Name" field automatically
fill in based on the previous rows "Last Name" entry as a default and I would
change if need be.

Thanks

Do you really have a field named "Date"?
Date is a reserved Access/VBA/Jet word and should not be used as a
field name.
See the Microsoft KnowledgeBase article for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'