Data from multiple tables without relationships

[Hartkoorn]

K,

Maybe a noob question, but I'm still learning access (I know a little late at the age of 37, but better late then never).
I have a form with several tabs, linked to a table with employee information, works like a charm.
Now, my last tab is called settings, maybe no need to say that the information from this tab needs to be called from a different table called settings.
Certain information, like version number, department, etc I want to display all the time in the header and I want to be able to manipulate that information through the settings tab.
I definately don't want any relationships with the employee table.
Is there a simple way to achieve this, I tried drag and drop but this leads to errors, so definately I do something wrong here.
Much appreciated,

 

[RV]

Paul,

any data you put on a tab page relates back to the record source of your form.
In other words, what you're trying to achieve is not possible.
Your request doesn't make sense, as your tab pages should only show related data.

RV

 

[Hartkoorn]

RV,
Wow, that was fast and clear!
I'm fiddeling about with it now, is a subform not going to work either? It just crossed my mind, but if not possible I'm not going to bother with it.
Ta

 

[Hartkoorn]

Sorry, clicked twice, forgive my double post

 

[boblarson]

Contrary to RV's answer, you can put it on the tab as a subform. You will choose to manually link when you set it up and then just don't set a link.

 

[Hartkoorn]

Ta,
Works! But still unable to show (for example) the version and department in the header.

 

[boblarson]

Are you talking about your form's CAPTION? If so, you will have to do so by using the correct syntax for subforms.

So, the syntax to put in the form's load event would be:

Me.Caption = "Department: " & Forms!MyMainFormName.MySubFormName.Form.MyControlThatShowsDepartment & "  Version: " & Forms!MyMainFormName.MySubFormName.Form.MyControlThatShowsVersion

Remember to change MyMainFormName to whatever the main form name actually is, MySubFormName to whatever your subform CONTROL is named, and MyControlThatShowsVersion or MyControlThatShowsDepartment to the actual name of the bound control on the subform that matches up with the correct data. REMEMBER: on your subform, when you create it, to change the name of the controls that you want to display on the form's caption to something that IS NOT the same as the field name in your table.

So, for example, if my table has Department as the field name, when I use the wizard to create my form, Microsoft has the default as Department as the control name for the control bound to Department. So, change the control name to something like txtDepartment. Then things should work for you.