It looks like you want to write 'Client Name' into the table that the new form is based on, right?
If yes, then you can definitely do this with raw SQL. The way it works is you write a command in SQL language, in quotation marks so that its a string, and then tell Access to use its SQL interpreter (DoCmd.RunSQL) to write into the database. I use the same technique in Python and Javascript if I am not using a library's methods to interface with a database.
Here's the code:
1. Write your SQL string:
Code:
Dim StrSql As String
StrSql = " INSERT INTO YOUR_TABLE_NAME ( THE_FIELD_YOU_WANT_TO_UPDATE ) VALUES ('YOUR_NEW_VALUE' );"
DoCmd.RunSQL StrSql
2. This is where it gets confusing:
The quotation marks around 'YOUR_NEW_VALUE' are important. But the value that you want to pass is in a variable, so you need to break out of the quotes to use that variable, so the SQL string becomes:
Code:
Dim StrSql As String
StrSql = " INSERT INTO YOUR_TABLE_NAME ( THE_FIELD_YOU_WANT_TO_UPDATE ) VALUES (' " & me.OpenArgs & " ' );"
DoCmd.RunSQL StrSql
Its cumbersome but reliable. You can substitute in a variable for YOUR_TABLE_NAME and THE_FIELD_YOU_WANT_TO_UPDATE in the same way, but you have to make sure that your quotation marks are exactly right. There are a lot of other SQL commands you can use instead of "INSERT INTO", like "SELECT", "UPDATE", or "CREATE DATABASE", but those are structured differently and you'll need to read up on them.
Also using all capital letters is usually just a convention that some people use for SQL, but I'm not sure that its necessary in Access. I would suggest using all capitals at first to make sure it works before you experiment around with lower case.