Keep field X in new record same as previous record

[Guest]

Okay I've got a form whose fields are this: DepartmentID, LastName,
FirstName, and Employee#.

I have a handwritten list that I'm typing up into this form. Now, I have
like 30 people per Department. What I would like is for the DepartmentID
field (which is a combo box with the Dept # and Names in the cbo) to stay the
same when I go to a new record UNTIL I change it. Like, okay if I'm putting
in 30 people under the same department, it's annoying to have to keep click
on the combo box and changing it to the correct department (it's MORE
annoying to have to continuously type out the Dept number and name so the
combo box is the lesser of these two evils).

I've seen a database once where someone had the date fixed where when you
hit enter and started a new record, the date field would hold the date of the
previous record over.

How do I do this?

 

[Rick B]

Do a search. Asked and answered allllll the time.

Please look for answers before posting new threads.

 

[Rick B]

As I posted a few days ago....


----------------------------------------------------------------------------
----
This is a very common question and I just addressed it yesterday. Check
out...

http://groups-beta.google.com/groups?q=microsoft.public.access+value+from+previous+record&hl=en

Many of the posts on the first page do what you ask. The one named "default
value in form" includes a link to a detailed Knowledge Base entry.