Special textbox/ form question

[Guest]

Question:

I have a table ( tblProjectManager ) that I store names of our current users
in ( ex. 'John Smith' ) I have a form ( frmManpower ) in which I have a
combobox which shows me these names and then they are stored in another
table. I want to be able to add a persons name to the tblProjectManager thru
a pop up form which will have a textbox and 'Save' & 'Exit' button.
I have created this form, and bound the textbox to the tblProjectManager
field, but when I open this form it shows the first record and when a new
name is entered it overwrites the first record. I do not want users of this
form to edit any names. Only if we have hired anyone new, then their name
could be added.
I think my direction would be to create vba code, and make the textbox
unbound, and on the after_update of the textbox ( or Save button click_event)
it would send the record to the table.
Could someone please help with this?
Thanks to all that reply

Mark

 

[Guest]

Guys, I have solved this:

On the Form_open event i wrote the following:

Private Sub Form_Open(Cancel As Integer)
DoCmd.RunCommand asCmdRecordsGoToLast
DoCmd.RunCommand asCmdRecordsGoToNext

End Sub

This works perfectly