Yes thats correct - one tab control with two pages.
When selecting tab one (Sök) it should select from tblSearch and when selecting tab two (Etiketter) then it selects from another table. All is inserted into myQ AND WORKS :-)
Now whats not working is that i want to show it in detail area in the form. Some kind of "on-change" i presume. The form (frmLabel) has myQ as a data source.
If theres a sub form on the tab then why cant the forms record source be used?
All is inserted into myQ AND WORKS :-) Not sure I understand that! Are you using a query (myQ) as the forms record source? (Same for BOTH sub forms)???
Any chance of seeing dB? ekspertenATsanthell.dk AT = @
If the form always opens on the first tab then you also need to set the query sql to the tblSearch, but if you set the recordsource to the SQL for case 0 it will always be set to that when opening the form.
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.