Creating a Timestamped activity list

[jvol]

I am trying to create a time stamped activity list as a subform in my access database.

Basically I have a table named tblTime with the following fields:

Timestamp
Location
Notes
ID

Location is linked to a list containing the values:

Start
Assigned to User
Sent to Client
Print
Close

I've created a Form called frmTime that contains

Txt box: Timestamp
Combo Box: Location
Txt box: Notes
Button: New Record

However, instead of having the button, I would like to be able to simply click on one of the options in the combo box and have the timestamp appear and also create a new record in tblTime with the Location value that was selected in the combo box.

I can set the timestamp to appear when an option is selected in the combo box, but this does not create a new record in the table - it simply changes the timestamp in the active Location record

I can make the form go to a new record when I select an option in the combobox and assign a timestamp, however this creates a new record without an option being selected in the combo box, and it changes the Location value of the previous record.

Access gurus of the universe.. please help me.. I've been trying to resolve this for days to no avail. Any help would be greatly appreciated.

[trevor40]

only one table can be linked to a forms record source at a time, you will have to have vba code to update the other table.
or you may be able to link them in a query and use that for the form record source.

[jvol]

This little time stamp app works as long as i have a button that creates the following scenerio:

1. User pushes buton
2. New record is created
3. Timestamp apears
4. User Selects Location
5. User writes a note
6. Record is saved

The idea is to get rid of the button and just make the timestamp and new record to be created when a location is selected.

I want to reduce 3 clicks to two

[ItsMe]

In the afterupdate event of an unbound combo you could use something like

DoCmd.GoToRecord acDataForm, "FormName", acNewRec
Me.Fieldname.value = Me.ComboName.Column(0)

Not sure if your combo is on a main form and you are trying for a new record in a subform. May need to adjust the code a little. I am also assuming the combo has some sort of relevance to the new record so I included a line to update the field.