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

Me.txtAddRec is bound to

=[Forms]![Table1]![txtAdd]

Select allOpen in new window

(you can find that in Control Source)
and there's an error returned with

#Name?

Select allOpen in new window

you got to resolve that first.

it seems that you're replicating your forms...

one quick resolution is to change:

If Me.txtAddRec = "Cap" Then

Select allOpen in new window

to:

If Me.txtAddRec1 = "Cap" Then

Select allOpen in new window

how to resolve this #Name? things?

I am not able to solve this, is there a way to solve this?

it seems that you're replicating your forms...

one quick resolution is to change:
If Me.txtAddRec = "Cap" Then

Select all
 
Open in new window

to:
If Me.txtAddRec1 = "Cap" Then

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.

how to resolve this #Name? things?

I am not able to solve this, is there a way to solve this?

you getting the error because you're referring to [Forms]![Table1]![txtAdd] while the fact that [Forms]![Table1] is yet not opened

is there a way to code that if the form is not open it can go to else condition or something?

i try the code that if Me.txtAddRec = "#Name?" then
do nothing
...
but that's also not working.

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.

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?

how you defined as "not working"?

I tried the Edit Record button and at least it get rid of that #Name? error.

#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.

just do a message out and see what you getting here?

...
MsgBox Me.txtAddRec

If Me.txtAddRec = "Cap" Then
...

Select allOpen in new window

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

Yes exactly.i use the similar method as you can see in image 3, but Add Source button is not working as  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.

It would be helpful if you can make this work in the sample DB attach, then i will implement that in my operational database.
IMAGE1.png
IMAGE2.png
IMAGE3.png

check your codes if below is correct...

Private Sub Command167_Click()

If Me.txtAddRec = "Cap" Then
    Forms!Table1!Source = Me.txtCap
    DoCmd.Close
ElseIf Me.txtAddRec1 = "CapEdit" Then
    Forms!Table1_1!Source = Me.txtCap1
    DoCmd.Close
End If

End Sub

Select allOpen in new window

>> ElseIf Me.txtAddRec1 = "CapEdit" Then
but value of txtAddRec1 is Cap1

hence nothing will be executed.

Thank you Ryan, you were right i was writing the wrong text "CapEdit", it started working in my database, thank you again.