tabbed form

[scottdg]

I am looking to create a form that displays a stores general information and then below has different tabs with additional info. One of the tabs would have owner information and another one would have employee information. Each of these could have multiple people so I want to be able to list the names in the tab and allow the user to select a name to open a new form displaying additional information. I am not sure how to accomplish this on a tab.

Thanks,
Scott

[ranman256]

usu, I have the master record say Client (single rec form)
and on it is the subform and the tabs (Payments, Purchases, Inventory...)
clicking on the tab, sets a new query to the subform. (so the form is not cluttered w many data screens)

The event on tabChange:

Private Sub TabCtl_Change()


Select Case TabCtl.Value
   Case 0
      chld.RowSource = "qsPayments"
   Case 1
      chld.RowSource = "qsPurchases"
   Case 2
      chld.RowSource = "qsInv"
End Select
End Sub

[scottdg]

I am not really sure what you are suggesting...

The problem I am having is that on a regular form if I limit the size of the detail sections it will repeat for as many records as I have in my set. I don't seem to have that option for a tab. I was able to include a subform on the tab with the list of names that I need. Now I am trying to figure out how to add a button that will select the record and open another form.

[June7]

You are using a Tab control?

Options:

1. set the subforms as continuous view and arrange controls to look like datasheet and this will allow buttons to show

2. I use double click event of subform to open another form

[McArthurGDM]

The approach I would take for this is to create subforms and set a parent/child relationship. It seems to me that if you had a correctly/normalized database design, then you have different tables relating all the information you suggested. In which case, just creating subforms.

The key to creating tabs that alter criteria based on what you click is to set one or the other subform controls to visible/not visible.

All the information is there on the form, but based on what you click, it becomes visible or not.

Having all that on one form would be hard and messy and cluttered, but I don't know any other more elegant method.