Split Form or Sub-Form

[psatkar]

Hello,

I am using Access 2007 and have a table called tblTransactionDetails. The fields available are TransId (PK), Trans_date, Trans_Type, Trans_Amt, Trans_Payee, Trans_Memo.

I want to have multi page (tabs) layout in the Main (?) form section and these pages will be called as "Spending", "Receiving" and "Transfer". The fields from tblTransactionDetails will be laid out in all these pages (tabs). These tabs will be used alternately based on Trans_Type (only one will be valid at any point of time) and purpose of this portion is to add/edit the current record.

At the same time, I also want to display the same table in datasheet view below the above mentioned multi page (tabs) layout in the same form so that multiple records from this table can be viewed at the same time.

I tried using Split Form functionality available in Access 2007. However, when I copy the same fields in multiple tabs/pages in the "form" section", it also creates the same column multiple times in datasheet view in the appearing in lower portion.

Is there any way, this functionality can be achieved using "Sub Form" or alternately can Split Form itself can be used by suppressing occurrences of same columns multiple times?

Thanks in advance...

Regards/ prasad

 

[Pat Hartman]

Not with the the A2007 version of the split form. It is not smart enough. You will need to create your own version from scratch. Create an unbound form to use as the container main form. Add the list type subform that you will use to choose records. Then add the tab pages and the details subforms. You'll need to manually create the master/child links because they will be subform to subform rather than mainform to subform. In the current event of the driving subform, you need to requery the child subform.