Run Time Error 13

C

computerpilot

I am trying to complete an EXTREMELY simple operation. I have VBA that
copies a text value from one form to another (providing the field is
empty or NULL). Both fields are EXACTLY the same (same properties in
both the table and form).

I can get this to work in any other form using the same code and
fields. However, whenever I run it in a particular form I have
created, it gives me a 'Run-Time Error 13' message.

Here is my simple code:

Private Sub Form_Current()
If IsNull(Me.Print_Order_User) Then [Print_Order_User] = Forms![Main
Menu].Print_Order_User
End Sub

I know that the Run-Time Error 13 message relates to passing a value
that does not have the same properties, but I swear that I checked
everything. Is there something else I am missing? FYI: The Form, "Main
Menu" is still open, only not visible during the code execution.

Thank you so much for your time and I look forward to hearing your
advice!
 
F

fin

Are you missing a "me." in front of second
Print_Order_User ?

Private Sub Form_Current()

If IsNull(Me.Print_Order_User) Then [me.Print_Order_User]
= Forms![MainMenu].Print_Order_User

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Error Code 30068-13(1058) - System Error 2
Shell command produces a "Run-time error '5': Invalid procedure call or argumen 0
Error 13 - Type Mismatch 1
Problem with form--subform 5
Some Code is Periodically Skipped 2
Type mismatch error after access 2007 conversion in form call 0
Dlookup error 13 7
Run-time error 3426 1

Top