How to delete certain fields in record on button press

[NikoTheBowHunter]

On my form at the top, drop down list, select the record and it populates the below fields with that records data. In this form, I have a section where I would like to create a button to clear only those fields. How would I accomplish this, coding/macro??? Obviously I need to a new button to clear these fields, but how would I code that button to clear only the fields I specify? Table/form/Field names are as follows:

{Table: Inventory}
{Form: Update Inventory}
[1234 Requested] = yes/no
[Date 1234 Requested] = date/time
[1234 Received] = yes/no
[First Name] = text
[Reg#] = number



Not all fields will always have data, sometimes only a couple of the fields will be completed. If someone could write the code for this or give me an example of the code so I can tweak it to work for my database it would be much appreciated.

Cheers.

[Bulzie]

Just set them all to null. On the OnClick of the button:
Me.[1234 Requested] = null
Me.[Date 1234 Requested] = null
...

Tip: Don't use spaces or special characters in names. So would be 1234_Requested or Date_1234Requested, etc.

[NikoTheBowHunter]

Tip: Don't use spaces or special characters in names. So would be 1234_Requested or Date_1234Requested, etc.

This is my first and probably only database I will ever set up. As such, why is it important not to have spaces in the field names? Is it just to help with coding or does the system sometimes dislike that extra space? And thank you for the help and tip!

[NikoTheBowHunter]

and that code worked perfectly for what I needed, thank you very much!

[Bulzie]

Yes best to not have spaces and special characters for coding mainly. Spaces you can get away with but special characters are used by Access for various things so best to avoid them. Usually I just use the words or an underline if I need space such as EmployeeNbr, Employee_Nbr, etc.

[alansidman]

It is not always a good idea to delete data in a Relational Data Base. You would be better suited to add an archive/inactive field (Yes/No) and then in your reports or queries use this to filter out that data.

[NikoTheBowHunter]

its a single table database, basically just tracks which phone we assigned a user. When we get the phone back, the users info is cleared so it can be assigned to someone else. no records are being deleted, just the data in those specified fields in the one record.