Query to take form input and add it as a new row to table

[Ostio]

Hello,



Recently I have started a project on access. Note that I am very familiar with Excel vba but very new to Access in general.

So I have created a form on access with around 20 things the user has to input, and given specific names to all of them(ex. txtDate, txtName, optShift) thinking I could insert a button with a code that would transfer the info in a separate table in a new row, hidden from public eye. My Excel mind thought it would be something like (not in code form cause it's not real code) :
Tables("dbResults").Cells( n + 1 ,1).value = Forms("ufABC").txtDate.Value
Of course, the "n + 1" doesn't mean anything, I'm just pointing that it has to go into a new row.

The problem is that Access works with queries, and I don't understand how to use them to make what I want. I want a submit button at the bottom of the form that sends the data to a table and clears all the fields in the form. I know I am not very clear, so feel free to ask me some questions.

Can someone help me with that?

[pbaldy]

You could use a query but the simplest (and most common) solution is to make the form's record source the table and each control's control source the appropriate field in that table.

[Ostio]

Thank you for your quick response,

I have tried that, but it allows the user to navigate through the entries, which I don't want. Is there a way to remove that?

[pbaldy]

Change the Data Entry property of the form to Yes.

[Uncle Gizmo]

Just to let you know this is has been cross posted at access world forums https://www.access-programmers.co.uk...d.php?t=305650 where I provided essentially the same answer! Please be advised that there's nothing wrong with doing cross posting but if you don't tell people, then you risk making people Cross!

[pbaldy]

More info:

https://www.excelguru.ca/content.php?184

[Ostio]

Thank you!

[pbaldy]

Happy to help and welcome to the site by the way!