Working with Tabbed forms

[abette]

Hi - I have a tabbed form in an Access database I am designing for process claims. Each tab represents a different fund type. My main table will contain the individual claims. I also have a table that contains just the funding type names. Each tab contains an identical form with all the same exact controls (control source is my claims table). Each has a fund type combo control that is bound to the funding type names table (like a lookup). I would like the funding type control for each tab to default to the fund type (which is the name of the tab). I thought I could do this by setting the default value for each control on the tab to the respective fund type (again is the same as the tab name) but when I do they all default to 1 tab name. Note, I created a tabbed form style for inputting records and than another separate tabbed form for updating. All videos I have seen regarding tabbed style forms show them being used as sub forms linked to the main or first sheet tab. That isn't quite what I want. I would like each to operate independently as their own form based on the funding type. Is this feasible or am I dreaming?!
Here's a sample of my form:

 

[Isaac]

That isn't quite what I want. I would like each to operate independently as their own form based on the funding type. Is this feasible or am I dreaming

You can certainly do that, and it kind of looks like you already have (?)

Just create a tab control, add a Page, and drag a Form object from the left-hand pane, onto that particular tab page. Independent form is creating, operating with no dependencies on anything else.

Set the recordsource of the form however you want

 

[Ranman256]

i only use 1 subform
this prevents memory problems of using 1 subform for each tab.
then when user clicks a tab, swap out the source of the subform

Select Case TabCtl4.Value
  Case "Phones"
     subFrm.SourceObject = "frmPhones"
  Case "clients"
     subFrm.SourceObject = "frmClients"
  Case "Invoices"
     subFrm.SourceObject = "frmInvoices"
End Select

 

[abette]

Hi Ranman256 - FYI I am not doing this via VBA code. I am manually using Access features and form commands.
Isaac - I can't seem to get each tab to operate as it's own form. I tried saving each funding type as its own form and them pulling them in as sub forms but it doesn't seem to work. Ugh.