<div>
Me.txtAddRec is bound to<br />

<pre><code class="code-1 nolinks" id="code-20-42402161-1"><span>=[Forms]![Table1]![txtAdd]</span>
</code></pre>
(you can find that in Control Source)<br />
and there's an error returned with <br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42402161-2"><span>#Name?</span>
</code></pre>
<br />
you got to resolve that first.
</div>


<div>
it seems that you're replicating your forms...<br />
<br />
one quick resolution is to change:<br />

<pre><code class="code-1 nolinks" id="code-20-42402167-1"><span>If Me.txtAddRec = &quot;Cap&quot; Then</span>
</code></pre>
<br />
to:<br />

<pre><code class="code-1 nolinks" id="code-20-42402167-2"><span>If Me.txtAddRec1 = &quot;Cap&quot; Then</span>
</code></pre>
</div>


<div>
how to resolve this #Name? things?<br />
<br />
I am not able to solve this, is there a way to solve this?
</div>


<div>
<blockquote>
it seems that you're replicating your forms...<br />
<br />
one quick resolution is to change:<br />
If Me.txtAddRec = &quot;Cap&quot; Then<br />
<br />
Select all<br />
&nbsp;<br />
Open in new window<br />
<br />
to:<br />
If Me.txtAddRec1 = &quot;Cap&quot; Then<br />
<br />

</blockquote>
<br />
both are different textboxes, if Source Search form open from add record it will pass value back to add record form and if it open from edit record form it will pass value back to edit record, that's the logic behind this.
</div>


<div>
<blockquote>
how to resolve this #Name? things?<br />
<br />
I am not able to solve this, is there a way to solve this?
</blockquote>
you getting the error because you're referring to [Forms]![Table1]![txtAdd] while the fact that [Forms]![Table1] is yet not opened
</div>


<div>
is there a way to code that if the form is not open it can go to else condition or something?<br />
<br />
i try the code that if Me.txtAddRec = &quot;#Name?&quot; then <br />
do nothing <br />
... <br />
but that's also not working.
</div>


<div>
Can you try implementing this in the sample db i have provided? because i am getting a lot of error and my db starts crashing with this function.
</div>


Wsm93--1_b.accdb

<div>
it is working for Add Record but it is not working for Edit Record in the sample DB you provided.i try the same in edit record but it's not working,any idea?
</div>


<div>
how you defined as &quot;not working&quot;?<br />
<br />
I tried the Edit Record button and at least it get rid of that #Name? error.
</div>


<div>
#Name? error is not there but it is not passing value also, instead #Name? , yourDefaultValue is there, this is what i mean not working like the edit record is still not passing value back.
</div>


<div>
just do a message out and see what you getting here?<br />

<pre><code class="code-1 nolinks" id="code-20-42403668-1"><span>...</span>
<span>MsgBox Me.txtAddRec</span>
<span></span>
<span>If Me.txtAddRec = &quot;Cap&quot; Then</span>
<span>...</span>
</code></pre>
</div>


<div>
Ryan, it's not about txtAddRec as that is working fine , it's about txtAddRec1 which is not working.
</div>


<div>
Yes exactly.i use the similar method as you can see in image 3, but Add Source button is not working as &nbsp;by not working i mean it;s not passing value back to edit form, any idea why? neither now it's not showing any error also.<br />
<br />
It would be helpful if you can make this work in the sample DB attach, then i will implement that in my operational database.<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/12_w50/1215226/IMAGE1.png" target="_blank" class="file-inline" title="IMAGE1.png (8 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>IMAGE1.png</a><br />
<a href="https://filedb.experts-exchange.com/incoming/2017/12_w50/1215227/IMAGE2.png" target="_blank" class="file-inline" title="IMAGE2.png (15 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>IMAGE2.png</a><br />
<a href="https://filedb.experts-exchange.com/incoming/2017/12_w50/1215228/IMAGE3.png" target="_blank" class="file-inline" title="IMAGE3.png (25 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>IMAGE3.png</a>
</div>


IMAGE3.png

IMAGE2.png

IMAGE1.png

<div>
check your codes if below is correct...<br />
<br />

<pre><code class="code-10 nolinks" id="code-20-42403691-1"><span>Private Sub Command167_Click()</span>
<span></span>
<span>If Me.txtAddRec = &quot;Cap&quot; Then</span>
<span>    Forms!Table1!Source = Me.txtCap</span>
<span>    DoCmd.Close</span>
<span>ElseIf Me.txtAddRec1 = &quot;CapEdit&quot; Then</span>
<span>    Forms!Table1_1!Source = Me.txtCap1</span>
<span>    DoCmd.Close</span>
<span>End If</span>
<span></span>
<span>End Sub</span>
</code></pre>
<br />
&gt;&gt;&nbsp;ElseIf Me.txtAddRec1 = &quot;CapEdit&quot; Then<br />
but value of txtAddRec1 is Cap1<br />
<br />
hence nothing will be executed.
</div>


<div>
Thank you Ryan, you were right i was writing the wrong text &quot;CapEdit&quot;, it started working in my database, thank you again.
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Attach is a sample DB. frmFirst is the first to open and then click Edit Record where Source field click that go to Search Source and then click on Add Source there the error is.<br />
<br />
In Add Record it is working but in Edit Record is the one where ahead it gives error, any help how to resolve this?<br />
<br />
Thank you.<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/12_w50/1215019/Wsm93--1-.accdb" target="_blank" class="file-inline" title="Wsm93--1-.accdb (4.4 MB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Wsm93--1-.accdb</a>
</div>
</div>


Wsm93--1-.accdb

Hi,

Attach is a sample DB. frmFirst is the first to open and then click Edit Record where Source field click that go to Search Source and then click on Add Source there the error is.

In Add Record it is working but in Edit Record is the one where ahead it gives error, any help how to resolve this?

Thank you.

MS Access -  Error 2447: There is an invalid use of the .(dot) or ! operator or invalid parentheses

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.