Command to delete eveything in a record besides 3 things

[cooglerj]

Hi, Im wanting to delete everthing in a record in the table tbl_m16a4_rco by using form frm_m16a4_rco_deissue. Everything needs to be deleted besides rack# ,rifle serial number, and rco serial number. What would be the best way to do this? any help is appreciated. WEAPONSDATABASE.zip

[June7]

There is no form by that name.

You can manually delete the data from each control.

If you want to run code:

Me!Last = Null
Me!First = Null
etc.

[cooglerj]

WEAPONSDATABASEAMT.zip Sorry here it is. Exactly where would I put the code? Sorry im an access newb

[cooglerj]

What im wanting to do is select that row and hit a button and it deleted the fields I wanna delete.

[June7]

Do you want to delete the data or delete the fields from table?

[cooglerj]

Sorry the data in that record selected

[June7]

The code needs to go in some event - button Click or form BeforeUpdate, etc.

The real trick with coding is figuring out what event to use.

Why are you saving all that marine info into every table? I presume each marine can have multiple equipment (pistols, rifles). Should have a table of Marines and then just save their ID into each of the equipment tables. Then the only data that has to be removed is the ID.

Maybe these tutorials will help you better understand relational database design http://www.rogersaccesslibrary.com/

[cooglerj]

Because thats the only way I knew how to do it. Could you give me an example of what code I would use for that table? Thanks for the input btw.

[June7]

Why would you need code to create a table?

A database can actually be built to function without a scrap of code. It would be a very simple db but it can be done.

But before even thinking about user interface, need to get the data structure correct. Identify the data entities and how they relate. Have you studied the referenced link or any other tutorials on relational database principles? Until you have a grasp of those principles, your db development experience will be constant frustration.

[cooglerj]

Why would you need code to create a table?

A database can actually be built to function without a scrap of code. It would be a very simple db but it can be done.

But before even thinking about user interface, need to get the data structure correct. Identify the data entities and how they relate. Have you studied the referenced link or any other tutorials on relational database principles? Until you have a grasp of those principles, your db development experience will be constant frustration.

Im talking about the code to delete the info from the selected row.

[June7]

I already provided that in post 2.

What you have to determine is what event to put code into. Do you want to use a button Click?

If your data were properly structured, this code would not be needed.