How to save results from a filter into a table

[jmmunoz2141]

I am currently creating an access db that will be used in a cafeteria to track how many meals employees eat throughout the day. There is one main form that has a text box (Text 32) employees enter their user id into and then click a submit command button (Command 35.) This command button runs a macro which applies a filter ([User ID] Like "*" & [Forms]![frm_cafe entry form]![Text32] & "*") that looks for the user id which then displays the users information on the form. I would like to know if it is possible for access to save the users information every time they enter their id number and click submit. What I would like to happen is whenever an employee clicks submit all the information that is displayed on the form as well as the date and time that they clicked submit will be added to a table or a report of some kind which can then be exported.

I've attached the database to this post. The form that users will interact with is called 'frm_cafe entry form' and the table used to store all user's information in is called 'tbl_users.'

I'm rather new to Access so I'm sure further elaboration is needed here so please let me know if I can provide any more info.



Thanks in advance for any help

[ItsMe]

Store the primary key values in an events table.

[jmmunoz2141]

Thanks for your help!

I ended up using an append query that runs whenever the cmd button is clicked. Works like a charm!