C
CW
I have a main page and 5 tab control pages carrying subforms with a variety
of info about each transaction.
I need to create an invoice form, which would consist of probably 3 separate
subforms sitting on one new tab control page.
The upper subform would show the name and address of the debtor. The middle
one would show the details of our services being charged and the bottom one,
the charges.
I have created the upper one, as a separate form, with its source being the
debtor table (name, account number and 4 address fields). I have used a combo
so that the name can be looked up, and when selected this pupulates all the
other fields. So far so good.
However when I place this subform on the tab control page, the combo does
not work - at least, it shows the names in its dropdown but when I select
one, it doesn't populate the rest of the fields for that debtor (address
etc), as it did when used as a standalone form.
What is going wrong and how can I achieve what I need to do??
Many thanks
CW
of info about each transaction.
I need to create an invoice form, which would consist of probably 3 separate
subforms sitting on one new tab control page.
The upper subform would show the name and address of the debtor. The middle
one would show the details of our services being charged and the bottom one,
the charges.
I have created the upper one, as a separate form, with its source being the
debtor table (name, account number and 4 address fields). I have used a combo
so that the name can be looked up, and when selected this pupulates all the
other fields. So far so good.
However when I place this subform on the tab control page, the combo does
not work - at least, it shows the names in its dropdown but when I select
one, it doesn't populate the rest of the fields for that debtor (address
etc), as it did when used as a standalone form.
What is going wrong and how can I achieve what I need to do??
Many thanks
CW