code doesn't work on other computers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've written the code at bottom to open certain forms in my db. It all works
fine on my computer, where I created the db. But when users at other
stations use the database, the click event that should execute the code
doesn't seem to do anything. Do I need to specify the database? Is there
something in their settings that needs to be changed? I'm not using the
Security feature. HELP PLEASE!


subject = Forms!frm_Search!txtSubject.Text
category = Forms!frm_Search!cmbCategory.Text
DoCmd.OpenForm FormName:="frm_Browse", view:=acNormal,
wherecondition:= category & " Like " & Chr$(34) & "*" & subject & "*" &
Chr$(34)
 
Are you sure that this works the way you expect.

The text property is only accessible for a control when the control has the
focus. At least in the versions of Access that I've worked with.

.value is not really required since that is the default property of a control

subject = Forms!frm_Search!txtSubject.Value
category = Forms!frm_Search!cmbCategory.Value
DoCmd.OpenForm FormName:="frm_Browse", view:=acNormal, _
wherecondition:= category & " Like " & _
Chr$(34) & "*" & subject & "*" & Chr$(34)

Note that I've used the line continuation character to continue the line of code.
 
Thanks for your reply. The code does work properly by moving the focus, but
you're right, using .Value is a better choice. Nevertheless, my original
probelm remains. The click event for the form doesn't work on every machine,
and I'm stumped as to why. I use the click event with DoCmd.OpenForm with
other controls that do seem to work on other machines. The only difference I
can perceive is that this DoCmd.OpenForm includes the wherecondition
criteria, while the functional code does not filter the form. I'm stumped
for now.
 
Back
Top