subform problems

[DowningDevelopments]

I am making a Receipts form with subforms for collecting diffrent types of
payment, ie cheques, cash, creditCard etc. and im using subfroms to collect
them the details of each.

The subform needs to collect and show more than one record so ive used a
continous subform to do this which seems to work for collecting data with
synchronisation of ReceiptNo (which is the PK in the receipts form and
foreign key in the cheque table) going on by importing in the ReceiptNo if
the subform is active using VBA.

Its recording all the data but wheni go back to veiw completed forms it
shows me empty, subforms with no data in them!

Ive checked the childlink fields and Link Master fields set to the
receiptNo's on the proper underlying tables.

Can anyone tell me why it doesnt retreive the subform information when i go
back to a completed form please?

With much thanks and regards

Amit Patel

 

[Allen Browne]

Open the subform in design view.
Make sure its Data Entry property is set to No.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

in message
news:[email protected]...