Home

Hit a wall - multi table form not working

%3CLINGO-SUB%20id%3D%22lingo-sub-920187%22%20slang%3D%22en-US%22%3EHit%20a%20wall%20-%20multi%20table%20form%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-920187%22%20slang%3D%22en-US%22%3EI%20am%20making%20a%20database%20to%20digitize%20our%20HR%2C%20Personnel%2C%20and%20Training%20files.%20I%20have%20made%20all%20of%20my%20tables%20and%20all%20of%20my%20data%20input%20forms.%3CBR%20%2F%3E%3CBR%20%2F%3EThen%20I%20tried%20to%20make%20an%20Employee%20Record%20form%20that%20has%20multiple%20tabs.%20Each%20tab%20has%20the%20%E2%80%9Csub%20form%E2%80%9D%20of%20a%20form%20for%20that%20particular%20data.%20For%20example%20the%20first%20tab%20is%20Status%20and%20uses%20the%20employee%20status%20form%20as%20the%20sub%20form%20on%20the%20tab.%20This%20should%20show%20name%20hire%20date%20termination%20date%20etc.%20another%20tab%20is%20training%20completions%20and%20so%20on%20and%20so%20forth.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20best%20I%20got%20out%20of%20this%20is%20the%20first%20tab%20showing%20the%20information%20of%20the%20last%20person%20entered%20(2%20entered%20for%20testing)%20but%20the%20other%20tabs%20show%20blank%20information%20or%20oddly%20the%20same%20thing%20you%20see%20on%20the%20first%20tab.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20just%20want%20a%20simple%20way%20for%20the%20end%20user%20(supervisors)%20to%20enter%20an%20employee%E2%80%99s%20name%20and%20be%20able%20to%20see%20all%20the%20information%20on%20that%20one%20person%20(all%20data%20associated%20with%20the%20name%20in%20all%20the%20tables).%20This%20way%20they%20can%20check%20training%20information%2C%20attendance%20issues%2C%20discipline%2C%20etc.%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20help%20I%20have%20been%20banging%20my%20head%20on%20this%20for%20days%20and%20it%E2%80%99s%20the%20last%20piece%20I%20need%20before%20loading%20the%20information%20and%20rolling%20it%20out.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-920187%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-926911%22%20slang%3D%22en-US%22%3ERe%3A%20Hit%20a%20wall%20-%20multi%20table%20form%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-926911%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F429505%22%20target%3D%22_blank%22%3E%40Wfoley82%3C%2FA%3E%20Make%20sure%20you%20link%20the%20subform%20to%20the%20data%20on%20the%20main%20form.%26nbsp%3B%20There%20are%20%22Link%20Master%20Fields%22%20and%20%22Link%20Child%20Fields%22%20properties%20that%20you%20need%20to%20set.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Wfoley82
Occasional Visitor
I am making a database to digitize our HR, Personnel, and Training files. I have made all of my tables and all of my data input forms.

Then I tried to make an Employee Record form that has multiple tabs. Each tab has the “sub form” of a form for that particular data. For example the first tab is Status and uses the employee status form as the sub form on the tab. This should show name hire date termination date etc. another tab is training completions and so on and so forth.

The best I got out of this is the first tab showing the information of the last person entered (2 entered for testing) but the other tabs show blank information or oddly the same thing you see on the first tab.

I just want a simple way for the end user (supervisors) to enter an employee’s name and be able to see all the information on that one person (all data associated with the name in all the tables). This way they can check training information, attendance issues, discipline, etc.

Please help I have been banging my head on this for days and it’s the last piece I need before loading the information and rolling it out.
1 Reply

@Wfoley82 Make sure you link the subform to the data on the main form.  There are "Link Master Fields" and "Link Child Fields" properties that you need to set.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies