Refresh Form Data

Here is the scenario:

Form 1 - Data entry for a new project

Form 2 - Data entry for a task associated with the project in the Form 1



Button on form 1 that opens Form 2.



What I am trying to do:

Use a combobox on Form Two to choose the Project entered into Form 1, so I can capture the Form1 PK as a FK on Form 2.



Here is the problem:



Refreshing the record on the button click so that the new option entered into Form 1 shows up in the combo box on Form 2.



Full disclosure:

I'm not much good at VBA so I have been trying to do this by customizing the button macro. I have tried Refresh, and Requery, but I can't seem to get it to update the list in the combo box.



2 questions:



1. How can I get this accomplished?

2. Is there a better way to get this data into the table than what I am trying to do?

Refresh Form Data