Inserting the Value of a Text box

[ChampionDuy]

I have a form that the user enters in Case information on. That form is based on table. I also have a table that holds information on who created this individual case. This table just holds the Case Number and the Username. When the user saves the case I need the table that holds the information on the creator of the case to be updated as well as the table that holds the case information. Which I already have working.

The 2 text boxes that I need help with are the Case_No and the Username.

I just need a row inserted into the tblCreator with the case number of the case created and the username.

I know there has got to be an easy answer to this but I cant figure it out.

I am not even sure if I should do this via a query or VBA or what.

 

[dcx693]

No coding is necessary for this. What you should do is create a query that joins the Case info and tblCreator tables. Then base your form on that query, instead of on one of the tables. Then make sure the fields on the form are bound to the query. That should update the Case and tblCreator tables.