Name Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...
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'
 
Back
Top