Insert into

[glasgowlad1999]

Hi There,



I am using Access 2010. I have a form that once submitted populates the main table. After the button is clicked i want it to take the [ID] from the newly submitted profile and add it to another table, then i want to update a checkbox. I want this determination table to highlight the ID as a newly open record before it can be approved or denied.

I have no idea how to make the button add the ID to the tbldetermination, "ReviewID" field and update the "Open" field checkbox to true for that ID.

Any help would be very grateful.

Thanks.

[orange]

What have you tried? Any error messages?
There are free video tutorials at
http://www.datapigtechnologies.com/AccessMain.htm

I'm not aware of anything so specific as your post, but there are plenty of examples of forms and controls.

[hertfordkc]

Orange said it: look at the examples. I think the Northwind sample database is very instructive.
Having said that, consider this.
Have the button on the first form open a second form with the default values for a new record in tblDetermination, i.e. in the ReviewID field, put Forms.Form1.ID. Default the checkbox to True. The property settings in the second form are critical to this working, in particular "Data Entry", "Allow Additions","Allow Deletions' and "Allow Edits".