Using macros in a Form

[Mill21]

Hi I have a database and I have a data input form and on the data input form I have some combo boxes that get data from another table and store the results in my main table.
I have set to limit data to items in the list so I I need to add data that’s not in the list I am unable to carry on inputting the data, I have set up a macro so when I try and add data that’s not in the list it opens a form to add data to the list, and store it in the relevent table, all this works ok.

So now my question
1 When the form opens how I get it to open in a new record position and not at the first record.

2 Then when I have entered the new data into the form and closed the form how do I get the data to refresh in the table. As it is now I enter the new data into the form that then enters the new data into the table but then I have to close the data input form and reopen it again to be able to select the new data in the table

[ajetrumpet]

When the form opens how I get it to open in a new record position and not at the first record.

the main or the popup to add recs?

[Mill21]

Hi ajetrumpet,
in answer to your question my original idea was to open the add record form in the new record position, but on second thought it might be good if my main data input form stated in the new record position as well.