Update from txtbox Help!

[jbh02]

Insert Into Table1 (Field1, Field2) = Select Max(Field1) from Table2 As Expr1, Forms.Form1.txtBox1 As Expr2;



Basically I am trying to Insert two fields in table1. The first is an aggregate getting the highest number from table2 field. The second one is a value in a txtbox on form1.

Cannot seem to get this to work together. I usually get an error.

Any help? I am pretty sure I am not addressing the txtbox correctly.

The "As Expr" came from my attempts at using the query builder. Not sure if they are needed.

[SoftwareMatters]

What is the error?
Try this:
Insert Into Table1 (Field1, Field2) = Select Max(Field1) from Table2 As Expr1, [Forms]![Form1]![txtBox1] As Expr2;