Recent content by justme

Thank you guys so much for your help and patience. I got it working, thanks very much to you. Syntax is tricky for me. I appreciate your help and time. kind regards, v/r, janet

Thank you PBaldy and Hammamabuarqoub, Yes, there are other required fields in the table. When i added your suggestion so i have Currentdb.Execute strSQL, dbFailOnError I get a Run-time error '3201': You cannot add or change in a record because a related record is required in 'tblMain'. I...

I now have the code the way you show it (silly me for not realizing that). strCpRq = Forms!frmMain!Rq strSQL = "INSERT INTO tblSubSnt (SntRq) VALUES('" & strCpRq & "')" CurrentDb.Execute strSQL I don't get any errors but still, nothing gets inserted into the table. I just don't know what i...

Thank you again PBaldy, I'm sorry to be so slow to understand. The code I have now is strCpRq = Forms!frmMain!Rq CurrentDb.Execute strSQL strSQL = "INSERT INTO tblSubSnt (SntRq) VALUES('" & strCpRq & "')" I get a Run-time error '3078': The Microsoft Jet database engine cannot find the...

Thank you PBaldy, The code I have now is strCpRq = Forms!frmMain!Rq CurrentDb.Execute strSQL = "INSERT INTO tblSubSnt (SntRq) VALUES('" & strCpRq & "')" I get a Run-time error '3078': The Microsoft Jet database engine cannot find the input table or query "False". Make sure it exists and...

Hi, Can anyone please tell me why the following code isn't working? There is data in a text box, txtRq, on frmMain. There is also a subform on frmMain, frmSubSnt. I would like the text in the txtRq inserted into the table the subform is based on, tblSubSnt. None of my searches resulted...

Thank you PBaldy, I appreciate your generous help and time. v/r, janet

Thank you for looking at my questions. I am using Access 2003 on Windows XP. Please help me with two questions about Filtering a Form on a Field in a Subform. I am able get this working the way it is set up at http://allenbrowne.com/ser-28.html. Question 1) I would like to use a...