Hi there!
I have a form that has bank details. The bank details dont usually change that much so they have been linked to the Main table rather than being specifically linked to each Projects year records. This means that I'll have to use a combo box on a payment form within one of the tab controls that will show the Account numbers and the user can just pick the correct account number for that record.
The problem I have is when I use the tblBankDetails as the record source and bound the colom to the Primary key but only show the account numbers I get all the account numbers from the table rather than just having the relevant account numbers for the related records.
It should only show perhaps 3 or 4 account numbers for the user to select instead of all 3000 or so.
How can I set this so that it will only show the account numbers for those projects?
Hope someone can help.
I have a form that has bank details. The bank details dont usually change that much so they have been linked to the Main table rather than being specifically linked to each Projects year records. This means that I'll have to use a combo box on a payment form within one of the tab controls that will show the Account numbers and the user can just pick the correct account number for that record.
The problem I have is when I use the tblBankDetails as the record source and bound the colom to the Primary key but only show the account numbers I get all the account numbers from the table rather than just having the relevant account numbers for the related records.
It should only show perhaps 3 or 4 account numbers for the user to select instead of all 3000 or so.
How can I set this so that it will only show the account numbers for those projects?
Hope someone can help.
