I'm having a bit of a tug of war trying get a label that I click on one form and then have it open another form using the Where condition.
I'm trying to pass the string value of a field on the current form frm_Speech that field in a combo box ServiceProvider.Column(0) to then open my next form frm_Orgn-temp to that specific records. My message box lets me know I have the right value but when I "OK" out of the message box I get a syntax error missing operator?
Private Sub ProviderLabel_Click() MsgBox ServiceProvider.Column(0) DoCmd.OpenForm "frm_Orgn-temp", , , "OrgnName=" & ServiceProvider.Column(0) End Sub
Hi Alex, nailed it!... Yes, OrgnName is a string. Thank you so much for not only the syntax solution but pointing me to the "Concatenation & the Double-Double Quote" video. So can't wait for the day when I can take command of VBA instead of feeling it to be a bit more mystery than solution. Thanks again!
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Payables Seminar.
