Access 2013 Set Property value
Posted on 2014-09-23
I'm working on a new project to create a receiving database for our warehouse. I have a form with a location textbox. What I would like is to be able to double click on the text box and have it open a form that lists all my storage locations in a grid or using individual buttons for the locations. I'd like to be able to select one or more locations and have them populate the location on the first form. Also to change the color of the buttons to show them as in use. I can open the form but I can't seem to get the syntax correct to send even one location back to the original form. I'm trying to use the set property value macro function but I can also use VBA if someone can suggest a way to do this.