Add record in subform through main form

F

fordrules01

Hi,

I have a form 'CentreMain' with a sub form 'CentreAddress' that displays the
multiple contact addresses (ie. Postal, Physical, Delivery, etc). When i try
to add a new address into the subform by clicking on it in the main form it
will not allow me to. I have tried adding a command button to bring up the
subform which i can edit from there but then I can't get it to load a new
record with the centre name already filled in. If possible I would prefer the
first method of typing it in directly from the main form but advice on either
would be appreciated.

Cheers,

Matt
 
D

Damian S

Hi Matt,

You shouldn't be repeating the centre name in your subform, simply link your
address records back to the centre then grab the centre name from the main
table.

Damian.
 
F

fordrules01

Sorry Damien. I should have clarrified better.

I don't actually have the centre name repeated in the subform. The
'addresstbl' and 'centretbl' are linked by the CentreID. My problem is that
when i add a subform to a form myself it does not allow me to add a new
record within the subform (ie, another address). If I however, create an
autoform based on a query of the 2 tables it adds the subform and I can add a
new record but the same problem occurs when I add a second subform to my main
for (eg. to show facilities).

There is obviously some setting that allows it to be done but i just can't
figure it out.

Thanks,
 
Top