Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-10-2019, 03:21 AM   #1
Arvive
Newly Registered User
 
Join Date: Aug 2019
Posts: 10
Thanks: 8
Thanked 0 Times in 0 Posts
Arvive is on a distinguished road
Form data

Dear Kindly assist me here.
I have the form in attachment used to assign designs to trainees to work on daily.
They can be assigned with multiple designs in a day.
When A trainee is selected and has designs for the same day already, I want the form to fetch those designs then the user can add new ones and also edit previous ones if needed.
Attached Images
File Type: jpg Screenshot_7.jpg (98.6 KB, 17 views)

Arvive is offline   Reply With Quote
Old 09-10-2019, 04:13 AM   #2
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,033
Thanks: 65
Thanked 2,561 Times in 2,458 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Form data

add Master/Child Fields Link to the subform:

Master Field Link: MainFormDateField, MainFormEmployeeCombo
Child Field Link: [Days], [EmployeeID]
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 09-10-2019, 04:41 AM   #3
Arvive
Newly Registered User
 
Join Date: Aug 2019
Posts: 10
Thanks: 8
Thanked 0 Times in 0 Posts
Arvive is on a distinguished road
Re: Form data

Quote:
Originally Posted by arnelgp View Post
add Master/Child Fields Link to the subform:

Master Field Link: MainFormDateField, MainFormEmployeeCombo
Child Field Link: [Days], [EmployeeID]
Please, I already have a link. there is a link field. on WORKID and HEADID Not an expert though. I may be wrong
Attached Images
File Type: jpg Screenshot_8.jpg (102.6 KB, 13 views)

Arvive is offline   Reply With Quote
Old 09-10-2019, 04:58 AM   #4
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,033
Thanks: 65
Thanked 2,561 Times in 2,458 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Form data

add the datefield and employeeid, so you can retrieve all designs for that particular employee on that particular date.

__________________
"Never stop learning, because life never stops teaching"
arnelgp 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 load data into and save data from text-boxes on a form keen1598 Forms 0 11-26-2014 09:27 AM
display data in form as select record in subform in data sheet view ootkhopdi Forms 14 11-13-2013 01:58 AM
Auto Populate Specific Data on a Blank Data Entry Form samjh Forms 1 01-27-2013 08:17 AM
Using a Form to query data and enter a price into a data table JahJr Forms 17 08-23-2009 03:48 PM
Passing data from main form to subform not saving data to table weilerdo Forms 0 03-02-2006 03:46 AM




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