Open Form with information from previous form

[jheintz57]

I know this is probably pretty simple and I am sure I have found the answer before but I am trying to open one form (Project) that is linked to another form (Site) via Site_ID. I need to enter data into the Project form and populate its associated Site_ID field with the selected site from the Site form. This work fine if there is already a record in the table of the Project form but not if there isn't one yet and a new one has to be created.



Thanks for the help.

[maximus]

Here I have a simple example. Open site Form. When you have a have a entry in the project form the command button will open that entry other wise if there is no record in the the project form a blank form is opened and the site_id of the project Form will be populated by the value of site_id in the site form.

Mark the thread solved if this solves your problem.

[jheintz57]

Thank you for the attempt to answer, unfortunately, the project form doesn't work. I get the error: "You can not assign a value to this object." I hit okay and the form is blank.

[maximus]

Strange it works fine on my machine. have you enabled macros option.

[jheintz57]

Yup I do, I am using Access 2007 though...could that be a problem?

[maximus]

Should not happen try copying the code on to another form. Try opening it as Access 2000 Database and see

[jheintz57]

It worked when I put it in a new database. Thanks. I will see if I can get mine to work based off this example.

[maximus]

mark this thead solved.

[jheintz57]

I wish I could...I get the same error when I try to apply it to my own form. I will work more with it and see if your fix will work.

[jheintz57]

Got it. Thanks