Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-31-2019, 09:39 PM   #1
access2010
Newly Registered User
 
Join Date: Dec 2009
Posts: 484
Thanks: 287
Thanked 0 Times in 0 Posts
access2010 is on a distinguished road
Stock Codes Not Matched on New Form

The stock codes are not coordinated (matched) with our new form = Equity Income = while they are matched with our form Purchases.

Could you please advise me as to what I have done wrong?

Thank you,
Crystal
Attached Files
File Type: mdb SubForm_Not Connecting_Stock_Code.mdb (1.42 MB, 19 views)

access2010 is offline   Reply With Quote
Old 05-31-2019, 09:49 PM   #2
June7
AWF VIP
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,410
Thanks: 0
Thanked 559 Times in 555 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: Stock Codes Not Matched on New Form

I don't see a form named Equity Income. There are 4 forms with Purchases in name.
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is online now   Reply With Quote
The Following User Says Thank You to June7 For This Useful Post:
access2010 (06-02-2019)
Old 06-01-2019, 01:37 PM   #3
access2010
Newly Registered User
 
Join Date: Dec 2009
Posts: 484
Thanks: 287
Thanked 0 Times in 0 Posts
access2010 is on a distinguished road
Re: Stock Codes Not Matched on New Form

June7, sorry for our error.

The form with the problem is, Investments_Purchases_IncomeF.

From the main form, we would click the button, Equity Income, which would open the problem form, Investments_Purchases_IncomeF

Thank you,
Nicole

access2010 is offline   Reply With Quote
Old 06-01-2019, 03:18 PM   #4
June7
AWF VIP
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,410
Thanks: 0
Thanked 559 Times in 555 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: Stock Codes Not Matched on New Form

Master/Child Link properties are not set for the subform container.
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is online now   Reply With Quote
The Following User Says Thank You to June7 For This Useful Post:
access2010 (06-02-2019)
Old 06-02-2019, 10:23 AM   #5
access2010
Newly Registered User
 
Join Date: Dec 2009
Posts: 484
Thanks: 287
Thanked 0 Times in 0 Posts
access2010 is on a distinguished road
Re: Stock Codes Not Matched on New Form

June7
Thank you.
The form now works.

Crystal
access2010 is offline   Reply With Quote
Old 06-21-2019, 12:33 PM   #6
access2010
Newly Registered User
 
Join Date: Dec 2009
Posts: 484
Thanks: 287
Thanked 0 Times in 0 Posts
access2010 is on a distinguished road
Re: Stock Codes Not Matched on New Form

June7
Thank you with your suggestion for having a "Link Child Fields" and "Link Master Fields" in the subform.
This suggestion has worked in all of the Sub Forms which we have created but one.
Do you have a suggestion as to what we should do with this occurrence?


Thank you.
Cryastal
access2010 is offline   Reply With Quote
Old 06-21-2019, 01:00 PM   #7
June7
AWF VIP
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,410
Thanks: 0
Thanked 559 Times in 555 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: Stock Codes Not Matched on New Form

Which subform?

__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is online now   Reply With Quote
The Following User Says Thank You to June7 For This Useful Post:
access2010 (06-21-2019)
Old 06-21-2019, 06:45 PM   #8
access2010
Newly Registered User
 
Join Date: Dec 2009
Posts: 484
Thanks: 287
Thanked 0 Times in 0 Posts
access2010 is on a distinguished road
Re: Stock Codes Not Matched on New Form

June7
Thank you for your response.
There was a space before the "Link Child Space", which has now been removed and the sub form is working.


Paul

access2010 is offline   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
Query to subtract current stock from previous stock aerozeppel Queries 11 09-19-2017 11:44 AM
Access VBA. Two codes in same form htadis Modules & VBA 7 02-02-2015 04:19 PM
Stock management - calculating available stock items garywood84 Queries 5 09-21-2009 12:14 AM
[SOLVED] Post codes/ Zip codes input masks angelrichardson General 3 02-11-2003 07:46 AM
returning to matched id upon closing a form segorese Modules & VBA 0 02-15-2000 06:11 AM




All times are GMT -8. The time now is 12:41 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