Looking for Access VBA assitance. Need to change code to look at table for a constant

[pjluckyman]

I currently have the ability to backup my database using a button. The VBA code has this line of code

Const BACKUP_PATH = "C:\mycomputer\my folder\"

I want to replace it with Const BACKUP_PATH = "form or table.field name". I want to be able to change the backup_file path depending on what computer the program is on so others can use the database with out having to know where to go and replace it in VBA.

Short and skinny I'm looking for the code in the middle of the " "'s to have my VBA look in a table or form for the value. I currently have a table named Link to Save with the field LinkToSave, and my form "Administration" with the text field named BackupLink.

Thanks in advance for your assistance.


Pete

[pjluckyman]

I currently have the ability to backup my database using a button. The VBA code has this line of code

Const BACKUP_PATH = "C:\mycomputer\my folder\"

I want to replace it with Const BACKUP_PATH = "form or table.field name". I want to be able to change the backup_file path depending on what computer the program is on so others can use the database with out having to know where to go and replace it in VBA.

Short and skinny I'm looking for the code in the middle of the " "'s to have my VBA look in a table or form for the value. I currently have a table named Link to Save with the field LinkToSave, and my form "Administration" with the text field named BackupLink.

Thanks in advance for your assistance.
Pete

I figured it out. BACKUP_PATH = Forms![Administration]![BackupLink] So simple it was hard!

[pbaldy]

Thanks for posting your solution and welcome to the site!