Help Needed: Linking form and tab control details (1 Viewer)

X

xygrax

Registered User.

Local time

Today, 14:10

Joined

May 11, 2018

Messages

10

• Feb 15, 2019

• #1

Hello Everyone,



I'd like to seek a little help with my form linking a Tab Control.



I have a form named "frm_Instructor-InspectorDB" where I want to pull up the the information of a certain employee profile from the Tab Control as soon as the form gets loaded after logging in.


I attempted to link these 2 but no luck.




Attached is the screenshot and the access to my database that i am working so you can get a view.





Thanks in Advance!


xygrax

 

Attachments

• 
  SS.png

  73.1 KB · Views: 46
• database.txt

  102 bytes · Views: 52

June7

AWF VIP

Local time

Today, 13:10

Joined

Mar 9, 2014

Messages

5,466

• Feb 15, 2019

• #2

Zip your file with Windows Compression and attach to post. 2MB zip allowed.

Tab control has nothing to do with filtering records. Filter must be applied to form. This can be done in OpenForm command.

 

Last edited: Feb 15, 2019

X

xygrax

Registered User.

Local time

Today, 14:10

Joined

May 11, 2018

Messages

10

• Feb 15, 2019

• #3

Hello,


I tried deleting some tables and forms but the size is still more than 2mb.


What i just want to do is just load the user profile information sitting in the tab control after logging in from the login form. Which really giving me a hard time doing so.





i've been working with this for 3 days now and still i am not able to figure this out

 

Minty

AWF VIP

Local time

Today, 22:10

Joined

Jul 26, 2013

Messages

10,368

• Feb 15, 2019

• #4

A tab control is simply an extension of the current forms area. So any control value on a tab is simply available under

Me.YourControlName

What have you tried that has failed ?
What error codes are you getting ?

 

moke123

AWF VIP

Local time

Today, 17:10

Joined

Jan 11, 2013

Messages

3,912

• Feb 15, 2019

• #5

in your log in form you have

Code:Copy to clipboard

                  DoCmd.OpenForm "frm_Instructor-InspectorDB"
                  Forms![frm_Instructor-InspectorDB]![TxtUser] = TempLoginID
                  Forms![frm_Instructor-InspectorDB]![txtEmployeeID] = EmployeeID
                  Forms![frm_Instructor-InspectorDB]![txtEmployeeName] = EmployeeName
                  Forms![frm_Instructor-InspectorDB]![txtEmployeeNum] = EmployeeNum

If I understand you correctly I think you want

Code:Copy to clipboard

                  DoCmd.OpenForm "frm_Instructor-InspectorDB",,,"EmployeeID = " & EmployeeID

and bind those textboxes to the appropriate fields

hth

 

missinglinq

AWF VIP

Local time

Today, 17:10

Joined

Jun 20, 2003

Messages

6,423

• Feb 16, 2019

• #6

xygrax said:

I tried deleting some tables and forms but the size is still more than 2mb.

Click to expand...

Kind of unusual...did you ZIP the file before attempting to attach it?

Minty said:

A tab control is simply an extension of the current forms area. So any control value on a tab is simply available under

Me.YourControlName

Click to expand...

That would depend, would it not, on whether or not the Tabbed Control simply held Controls from the same RecordSource as the Main Form...or whether it held Controls from a Subform on the Tabbed Control.



Linq ;0)>

 

June7

AWF VIP

Local time

Today, 13:10

Joined

Mar 9, 2014

Messages

5,466

• Feb 16, 2019

• #7

Be sure to run Compact & Repair before zipping file.

Still an extension of form area. Tab control has no bearing on how other controls are referenced.