Autofill data on another form

[lccrews]

I'd like to know if it's possible to write VBA that will (from form 2):


1. open form 1
2. write information from two fields on form 2 to form 1 [field1] and [field2]
3. close form 2
4. display a message.

I have form 1 that is a precursor to everything in form 2. Form 2 has subforms and calculated fields that point to information from form 1 [field1] and [field2].

Problem is, when there is no data written the user has to open form 2 to enter in information on [field1] and [field2] only to close the form themselves and retype the information in form 1.

I'd like to automate this process. Can this be done?

[June7]

Almost anything is possible with enough code.

Don't understand data structure nor the process you want to implement. Why is data duplicated?

[lccrews]

June! Maybe you can help me with this. I thought of another way to attack this problem. Instead of having redundant information on two forms, I could try a 'not in list' event that would add the information I need to the table before opening form 2. The problem is. I cannot get this code to work. Nothing happens.

StrSql = "INSERT INTO tbl_RawMaterial([Raw Material]) " & _ "VALUES ('" & NewData & "');"
DoCmd.SetWarnings False
DoCmd.RunSQL StrSql
DoCmd.SetWarnings True
Response = acDataErrAdded

[June7]

Is LimitToList property set to Yes?

http://www.fontstuff.com/access/acctut20.htm

[lccrews]

You're a champ. That was a simple fix. Thanks June.