Add Record

[Marianna_Air]

My add record button on the tool bar at the bottom of my form has stoped working. I get a error 2447 Invalid use of . (dot) or ! operator or invalid parnethese

Private Sub Form_Current()
strTmp = IIf(IsNull(Me!RequestforQuotesID), "Null", Me!RequestforQuotesID)
Location.Requery
DoCmd.Maximize
'PrepareITtmpForSubform (strTmp)
If (IsEditable) Then
Me.AllowEdits = True
Me.Request_For_Quotes_Subform.Locked = False
Else
Me.AllowEdits = False
Me.Request_For_Quotes_Subform.Locked = True
End If
End Sub

[Rod]

If (IsEditable) Then

seems highly dubious to me. What is 'IsEditable?' Is it a module level boolean variable or perhaps a function returning a boolean? If so the parentheses are redundant and probably causing your error.

While commenting on your code, have a look at

strTmp = IIf(IsNull(Me!RequestforQuotesID), "Null", Me!RequestforQuotesID)

The only VBA variable type that may contain a null is a variant. (Yes, I know any control on a form may be null or any column in a table may be null - but that's different.) Tthe tag 'str' suggests the receiving variable is a string. However because (I guess) you have not specified Option Explicit then VBA will default strTmp to be a variant. It's not used anyway since the appropriate line is commented out.

[Marianna_Air]

I'm so lost with this still, I've tried finding some kind of temp table that has anything to do with this but no luck

[Marianna_Air]

Solved this on my own, located a SN table and module