Subform New Record

[Peter Hoskin]

Hi,

I am creating a database for a video store as a college assessment. I
have a form containing customer details and a transaction id (linked to
videos the customer has rented). The rented items are listed in a subform.

What I need to do is to be able to create new records in the subform,
however the navigation buttons are blanked out if there is no data in
the subform, and the new record button is always blanked out.

The table the subform is retreiving data from contains the transaction
id, could this be part of the problem?

Any advice would be appreciated.

Regards,
Peter Hoskin

 

[Nikos Yannacopoulos]

Peter,

Open the subform in design view and check its Allow Additions property on
the Data tab. My guess is it is set to No, in which case you need to set it
to Yes.

HTH,
Nikos