Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-15-2019, 11:08 AM   #31
billgyrotech
Banned
 
Join Date: Apr 2013
Posts: 258
Thanks: 67
Thanked 3 Times in 3 Posts
billgyrotech is an unknown quantity at this point
Re: Lock Fields on Form and Subform Based On One Field Value

When I try to close the form I get the message. Oh by the way when previewing or printing reports I put Me.Refresh in the codes. I hope that is proper.

billgyrotech is offline   Reply With Quote
Old 06-15-2019, 11:25 AM   #32
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,778
Thanks: 57
Thanked 1,266 Times in 1,247 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Lock Fields on Form and Subform Based On One Field Value

Quote:
Originally Posted by billgyrotech View Post
When I try to close the form I get the message. Oh by the way when previewing or printing reports I put Me.Refresh in the codes. I hope that is proper.
Re: Me.Refresh - It depends on what your intention was. Typically, if you want to make sure the data is saved, you would use:
Code:
If Me.Dirty Then Me.Dirty = False
Okay, I clicked on the new button, and entered the data as I posted above. When I tried to close the form, I got an error message about the Disposition dropdown. To fix that, I had to remove all the default values for numeric data from your table (except for Labor Hours). Try the attached now...
Attached Files
File Type: zip AFR System 12.2.zip (1.13 MB, 9 views)
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
billgyrotech (06-21-2019)
Old 06-15-2019, 11:40 AM   #33
billgyrotech
Banned
 
Join Date: Apr 2013
Posts: 258
Thanks: 67
Thanked 3 Times in 3 Posts
billgyrotech is an unknown quantity at this point
Re: Lock Fields on Form and Subform Based On One Field Value

Thank you DBguy you have been most helpful. So far it is very good.


On the New AFR the main form looks like it all works fine. However I cannot add parts. I am sorry this has been very complicated. This part can wait if you don't have time I will see what I can do.

billgyrotech is offline   Reply With Quote
Old 06-15-2019, 11:52 AM   #34
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,778
Thanks: 57
Thanked 1,266 Times in 1,247 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Lock Fields on Form and Subform Based On One Field Value

Quote:
Originally Posted by billgyrotech View Post
Thank you DBguy you have been most helpful. So far it is very good.

On the New AFR the main form looks like it all works fine. However I cannot add parts. I am sorry this has been very complicated. This part can wait if you don't have time I will see what I can do.
Okay, yes, I am getting ready to leave again. I'll let you give it a try and let us know how you get along. Good luck!


PS. Just out of curiosity, I took a quick look at your subform for adding parts. You have its Allow Additions property set to No. See what happens if you set it to Yes. Cheers!
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 06-15-2019, 11:58 AM   #35
billgyrotech
Banned
 
Join Date: Apr 2013
Posts: 258
Thanks: 67
Thanked 3 Times in 3 Posts
billgyrotech is an unknown quantity at this point
Re: Lock Fields on Form and Subform Based On One Field Value

Perfect the allow additions did it. Thanks so much I will close this thread and get back to work on the database Monday.


Cheers to you too!
billgyrotech is offline   Reply With Quote
Old 06-15-2019, 12:06 PM   #36
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,778
Thanks: 57
Thanked 1,266 Times in 1,247 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Lock Fields on Form and Subform Based On One Field Value

Quote:
Originally Posted by billgyrotech View Post
Perfect the allow additions did it. Thanks so much I will close this thread and get back to work on the database Monday.

Cheers to you too!
Have a good weekend. Good luck with your project.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
lock field in record based on input from another field murray83 Modules & VBA 4 06-10-2017 09:52 AM
need to lock button based on subform HRakibul Forms 12 09-02-2014 11:20 AM
disable / lock fields on form & subform based on checkbox fibayne Forms 7 02-16-2014 02:09 PM
lock a field on main form if a field on a subform is complete? KevinSlater Forms 4 10-26-2005 12:00 PM




All times are GMT -8. The time now is 01:02 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World