Add a new record to a table (1 Viewer)

[Andy_CD]

I have a table that I would like users to update. Ideally I would like them to press a button that then opens a message box or form where they can enter their name. Then with another button click their name is added to the field in the table. This table then feeds a picking list for something else later on.
Cheers!

 

[bob fitz]

Then with another button click their name is added to the field in the table.

In an existing record, in which case which one or in a new record.

 

[Andy_CD]

Hi Bob,
sorry wrote it all a bit too quickly!
So I want it to be appended to a field in the table as a new record

 

[bob fitz]

You could open a form, bound to the table, and have a combo box on that form which lists all the users in your users table. The combo box would be bound to a field in the table of the new record.