I have a small db Access 2003 db that I've created for tracking my home music collection. At present, I use 2 yes/no fields to track the location of the music: iTunes (yes/no) and Cold_Storage (yes/no). Due to disk space consideration, I periodically move some of the music to an external disk (hence the cold storage name). If the iTunes field is checked (yes), then the Cold_Storage field is not (no). What I would like to do is to have a means to automate my form so that I can open a record and with one click have it change the location (in the db; I am still going to manually move the files). It would probaby also be a good idea to make sure that if the album is in iTunes, it is not in cold_storage, and vice versa.
Is there a easy way to do this with a form? The form name is Edit Album Information, the table name is Albums.
Thanks for your expertise!
Guiseppe
Is there a easy way to do this with a form? The form name is Edit Album Information, the table name is Albums.
Thanks for your expertise!
Guiseppe