Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Forms Help
Leo Rivera 
    
5 years ago
Richard hi, I create a VBA code in one subform which execute open another form this new form has two field that I want to be replicate from the excecution form.  I used Forms!Formsname!FieldName on the default value. When I run the code from the form work fine but when I excecuted from a subform an error is reflected #Name?
Adam Schwanz  @Reply  
           
5 years ago
Do Forms!FormName!SubformName.Form!FieldName Value From a Form
Leo Rivera OP  @Reply  
    
5 years ago
Not work! do you read my statement? I used Forms!Formsname!FieldName and is working only if I executed from the form alone.  But this form reside on another form as subform when I excecuted from there I have an error #Name.   Actually I saw that video first.
Leo Rivera OP  @Reply  
    
5 years ago
Sorry sorry sorry I see your code line adding dot and subform let me try.
Leo Rivera OP  @Reply  
    
5 years ago
Sadly, not work still having #Name in my field please help.
Kevin Robertson  @Reply  
          
5 years ago
Leo,

Can you post some screenshots so we know EXACTLY what you're doing. Images usually help more than text alone.
Leo Rivera OP  @Reply  
    
5 years ago
How can I attach the screen shots?
Kevin Robertson  @Reply  
          
5 years ago
In the upper right corner of your original post there us a link to upload images,
Adam Schwanz  @Reply  
           
5 years ago
Adam Schwanz  @Reply  
           
5 years ago
Fast video of how to get screenshot and how to attach on this website.
Leo Rivera OP  @Reply  
    
5 years ago

Leo Rivera OP  @Reply  
    
5 years ago
I need to send 5 images so I can explain my self right this one is one of five images
Leo Rivera OP  @Reply  
    
5 years ago

Leo Rivera OP  @Reply  
    
5 years ago

Leo Rivera OP  @Reply  
    
5 years ago

Leo Rivera OP  @Reply  
    
5 years ago

Leo Rivera OP  @Reply  
    
5 years ago
As you can see it is working but when I executed from the subform does not.
Adam Schwanz  @Reply  
           
5 years ago
So your first image is opening the form directly from the navigation pane? And the 3rd image is when it's a subform?
Leo Rivera OP  @Reply  
    
5 years ago
Yes
Adam Schwanz  @Reply  
           
5 years ago
Where is SARID? Is it a hidden field?

I'm still thinking my suggestion is what you need to do. Can you share the code you tried to use for that? Also verify that you're using the form PROPERTY name, which may or may not match the ACTUAL name of the form. Your subform could be SARF normally but it's name could be SARSubform (or anything) inside of the form it's a subform on, in which case you need to use SARSubform in the syntax.
Kevin Robertson  @Reply  
          
5 years ago
These screen shot tell us very little. How are you coding? From what I see you are selecting a Check box (image 3) and opening a single form. Is this correct?
Leo Rivera OP  @Reply  
    
5 years ago

Leo Rivera OP  @Reply  
    
5 years ago
Any body have an idea to fix this problem?
Adam Schwanz  @Reply  
           
5 years ago
Can you share the code you tried to use for mine? The Forms!FormName!SubformName.Form!FieldName

And what the actual subform name is called on that form? (Not neccessarily the same as the name of the form). If you see the image, the name can be different than the actual source object. You need to use the Name not the source object.

I'm still inclined to believe this is the problem.
Adam Schwanz  @Reply  
           
5 years ago

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/7/2026 3:18:36 PM. PLT: 1s