Deleting Records from Table

[SueAccess]

I have a simple form with a subform on it (see enclosed Access 2000 Database). I'm trying to add/change/delete records from table: Component Name. Adding and changing records is not a problem but deleting is. It only deletes the value of the field "Interative Component Name" and not the entire record. I have my joins defined properly on the tables. What am I missing? I wish this Access stuff was easier to learn. Any help/clues would be greatly appreciated.

Thanks

Sue

 

[daveUK]

All you need to do is add a command button to the form and follow the wizard to delete the record. I've attached the updated example.

HTH

 

[SueAccess]

Thanks a lot for the quick response HTH but isn't there a way of doing this without a button? I don't need a button to add a record. I thought Access could handle this properly without a button. Is that not the case? I don't need a button to add a record.

I just noticed that my relationship is wrong (i.e. the "Cascade Delete related records").

 

[SueAccess]

I think HTH misunderstood my question. I'm trying to delete records from the subform "Name of Component" and not from the main form (i.e. the web site name).

 

[RV]

If you want to delete records on your subform, you should put the command button on your subform, not on your main form.

It only deletes the value of the field "Interative Component Name" and not the entire record.

I guess you're confused 'cause you actually do see a value 0 (zero) in your table.
Well, actually what you see is your default column value in a new record.

BTW, your table structure is not correct.
Define Key as an autonumber column on your main table.
You should seriously consider adding a primary key (also autonumber) to your component table.

RV