Pass data from fields into table and reset fields

[megatronixs]

Hi all,

I have a database that will register the emails comming in and what time, also the time, date out and person.
I have a form with the fields to be filled in and a submit button. There are some fields that are automatically filled in and others need manually fill in.

below that part is a sheet (subform in the form of sheet) that should be filled in with the above data. Once it is there, it should empty the fields so they are ready to be filled in again. If I fill new data and press the submit button, it should go to the next available row.

Is there some one who could put me on the right track?

Thanks in advance.

Greetings.

 

[CazB]

try this?

basically I've unlinked the main form and subform so you get everything in the subform, changed the main form to data entry and changed the Event on the button so it goes to a new record after submitting the one you're on

 

[megatronixs]

Hi CazB,

Many thanks for your help, really works nice. (I did post a thank you before, but I don't see this).
One more question how about to make it shared. How can it be used by more people at the same time without overwriting each others data?

Greetings.