Access 2013 Set Property value

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.

Thanks'
MwvarnerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
I'd like to be able to select one or more locations and have them populate the location on the first form.
Are you really trying to put multiple values into a single column?  Can you post pictures of both forms?
0
MwvarnerAuthor Commented:
I'll do better than that.  I'll attach the sample DB I'm using to figure this out.  Form 1 is the main for.  double click on Location and form 2 opens.  I'm trying to have the caption of the buttons set as the location on form 1.  I can't get even one button to work much less multiple locations.  However multiple locations is what I'll eventually need.

Marshall
Database11.accdb
0
Jeffrey CoachmanMIS LiasonCommented:
?
With no data, ..it is difficult to see what you are after here...
Can you post a "working" sample database?

JeffCoachman
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

MwvarnerAuthor Commented:
This is all I have.  I'm just trying to workout how to set the value of the location box on Form1 from a button on Form2.

Clicking on the button A1 on form 2 should set the value in the location text box on Form1 to A1.
0
Jeffrey CoachmanMIS LiasonCommented:
Clicking on the button A1 on form 2 should set the value in the location text box on Form1 to A1.
Then you are using the incorrect terminology.

To do what you are asking does not require "Set Property" at all,...

All you need is something like this on the button:
Private Sub CmdA1_Click()
    Forms!Form1!Location = Me.CmdA1.Caption
End Sub

...obviously, ...both forms need to be opened in order for this to work...

JeffCoachman
0
Jeffrey CoachmanMIS LiasonCommented:
If you need this to be cumulative for multiple buttons, ...use something like this:

Private Sub CmdA1_Click()
    Forms!Form1!Location = Forms!Form1!Location & " " & Me.CmdA1.Caption
End Sub

Private Sub CmdA2_Click()
    Forms!Form1!Location = Forms!Form1!Location & " " & Me.CmdA2.Caption
End Sub

Private Sub CmdA3_Click()
    Forms!Form1!Location = Forms!Form1!Location & " " & Me.CmdA3.Caption
End Sub

Private Sub CmdA4_Click()
    Forms!Form1!Location = Forms!Form1!Location & " " & Me.CmdA4.Caption
End Sub

Private Sub CmdA5_Click()
    Forms!Form1!Location = Forms!Form1!Location & " " & Me.CmdA5.Caption
End Sub


JeffCoachman
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
;-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.