User Profile

alekseiaiteno · May 11 '12, 05:59 AM

IT WORKS!
the code you advised above

Code:

Me.txtContainer.DefaultValue = "'" & Forms!frmExport.txtContainer & "'"

seems to do the requested operation.

As for the Msg box it said previously: Default value is set to:AAAA1234567
With the new code it adds single quote marks around the AAAA1234567

CONTAINER is a text field (what I now understand is a string in Access terms)....

alekseiaiteno · May 10 '12, 06:29 PM

Mihail, NeoPa, I'm back to try what you suggest as you definitely have more savvy that I do.
Not quite sure what "this will force the user to fill all required fields. How you implement the ESCAPE option" and "that will automatically dirty the buffer on entry to the form" mean :) but let's leave this aside.

I have added the code you suggested above

Code:

Private Sub Form_Open(Cancel As Integer)

...

alekseiaiteno · May 9 '12, 05:46 PM

I think I may have found the workaround in a slightly different way.

I have updated the code in the frmExpense:

Code:

Private Sub Form_Load()
    
    If Me.NewRecord Then
    Me.txtCONTAINER = Forms!frmExport.txtCONTAINER
    End If
    
End Sub

Notice I've changed the Form_Open to Form_Load. And the DefaultValue is gone.
This creates a new record and puts the...

alekseiaiteno · May 9 '12, 02:25 PM

That is the thing - the messagebox did not return anything - no message displayed.

alekseiaiteno · May 9 '12, 09:18 AM

Unfortunately nothing new - no #Name? error, but also blank in the required field.

alekseiaiteno · May 9 '12, 07:11 AM

Hello NeoPa,

thank you for the explanation.
I have now changed the name to txtCONTAINER in both forms and inserted the code you advised to Open state of frmExpense. That yields the same result with the #Name? error.

I also tried to leave bits of my previous code in:

Code:

Private Sub Form_Open(Cancel As Integer)

    If Me.NewRecord Then
    Me.txtCONTAINER.DefaultValue = Forms!frmExport.txtCONTAINER

...

alekseiaiteno · May 8 '12, 09:39 PM

don't know what exactly yu are referring to as I have 2 Forms and the CONTAINER in both refers to a record in the initial table, so I really cannot change the one of these as then it would not work.

Perhaps you could explain more precisely or some more info needed from my side?

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

#Name? error in Access Form when trying to add new record