Recent content by jlfvlf

When I put the "& AND in the middle of my two WHERE statements, I receive a compile error, Expected: list or separator or ) When I put & AND in the middle of my two WHERE statements, I receive a Syntax error (missing operator) in query expression '[Field1]=("Brown") & AND [Field2]=("Blue")'.

On my form, I am trying to update one field in a table where results are based on two fields. My code that is not working is: DoCmd.RunSQL ("UPDATE tbl_1 SET [Field3]=(""" & Yellow & """) WHERE [Field1]=(""" & Brown & """) & [Field2]=(""" & Blue & """);") I have only been able to update with...

arnelgp THANK YOU SO MUCH.

After creating all the DIM statements and setting the statement to the correct field, I type: DoCmd.RunSQL ("INSERT INTO tableA (Field1,Field2) VALUES (""" & iField1 & """),(""" & iField1 & """)") DoCmd.RunSQL ("INSERT INTO tableB (Field3,Field4) VALUES (""" & iField3 & """),(""" & iField4 &...

Thanks for the help. June7, I will try the Locked Yes and Tabstop No when I get to work in the morning. It is working at home on a two simple tables and a query, but at work there are many more columns in each table so I will start from the basics and try to figure it out. I don't need to do...

I am wanting to view the description of an item in table B that is linked to table A which contains the auto id.

I have a query that has two tables linked many to one. When I view the query results, all four field(three from table A and one from table B are visible. When I pull the query into the form, the three from table A are populated in text boxes but the field from table B is blank. Please help.

From Texas. Intermediate Access user but I want to get better on the advanced things.