Is it posssible to filter tabbed pages

[John]

I am trying to design a form for payments in and out from varoius accounts,
using the four tables listed below. I had planned to set up tabs on a form
to have a different tab for different transactions. For example have one
page to filter all lodgements and inputs and the other to filter only
payments out, (using the transaction type as criteria. However I cannot see
any way to filter the tabbed pages individually. Is it possible to filter
tabbed pages individually.

John


tblPayments
pkPaymentID
PaymentNumber
PaymentDate
PaymentAmount
fkCustomerID
fkBankDetailID
fkTransactionTypeID

tblBankDetails
pkBankDetailID
TransNumber
TransDate
TransAmount
fkTransactionTypeID

tlkupTransactionType
pkTransctionTypeID
TransDescription

tblCustomers
pkCustomerID
name, address etc.

 

[PC Datasheet]

Hi John,

The answer to your question is Yes! Create an unbound form and put your
tabcontrol on that form. For each transaction, create a subform. Put each
subform on a separate tab. Base each subform on a query that includes the
transaction field and set the criteria for the appropriate transaction and
you will have different transaction records on each tab.

 

[John]

Thanks, I'll try that.

John

Hi John,

The answer to your question is Yes! Create an unbound form and put your
tabcontrol on that form. For each transaction, create a subform. Put each
subform on a separate tab. Base each subform on a query that includes the
transaction field and set the criteria for the appropriate transaction and
you will have different transaction records on each tab.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com