Computer Learning Zone CLZ Access Excel Word Windows

Education is the best friend. An educated person is respected everywhere. Education beats the beauty and the youth.

Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
Home > TechHelp > Access >

Back to TechHelp

Linked Form ID Carryover Upload Images   Link  
Caleb Hansen 
2 months ago
After creating a new Project record I'd like to have a button on my Project Form called "New Bid" that opens the related Bid Form to a new record, copies the ProjectID in the related field on the Bid Table, and displays the "Project Name" field only (no ID), from the Project Form/Table, on the top of the Bid form from. Thank you all for the help. You're awesome!
Kevin Robertson
2 months ago
Default Value
Caleb Hansen
2 months ago
Sorry Kevin, that's not really what I'm looking for.
Adam Schwanz
2 months ago
Can you elaborate some more then? Maybe with pictures? That sounds exactly like what a default value is for.

The only other thing I could think you may be talking about is DLookup but that only maybe applies to the last part of your question.
Caleb Hansen
2 months ago
Sure. Thanks for your patience. I have 2 related tables, ProjectT and BidT. BidT has the foreign key of ProjectID from the ProjectT. I also have 2 forms, ProjectF and BidF. After filling out the fields in the ProjectF, the user clicks the "BidButton" to "DoCmd.OpenForm "BidF", , , , acFormAdd." I'd like for that button to also carry the ProjectID that was just created in the ProjectF into the foreign key field of the BidT so that the user doesn't have to keep entering this info. I would like the BidF to open with the ProjectName, sharing the same ProjectID above, in a Textbox at the top of the form. I agree that last part should probably be a Dlookup function, but I'm a bit fuzzy on the code for the criteria. For the first part, I don't see in the default value videos an example of what I'm looking to do. All of this would be moot if I just made BidF a subform, but BidF will have its own subform and it will be getting too big a crazy at that point. Thanks again

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to TechHelp Comments

Start a NEW Conversation
Only students may post on this page. Click here for more information on how you can set up an account. If you are a student, please Log On first. Non-students may only post in the Visitor Forum.
Subscribe to TechHelp
Get notifications when this page is updated

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

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard

Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Copyright 2023 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 2/8/2023 1:58:16 PM.