Search form only works for me

  • Thread starter Thread starter Steve Scott via AccessMonster.com
  • Start date Start date
S

Steve Scott via AccessMonster.com

I have a multi-criteria search form(frmCARPAR_Search) (It has 5 unbound
controls) with a subform search result. The query (qryTableDataSearch)
that generates the data for the subform uses the following criteria:
Like "*" & ([Forms]![frmCARPAR_Search]![DocumentNumber]) & "*"
for each of the 5 criteria though the control name differs.

Anyway, without any security on this database, I placed it on the network.
For me, it works fine. For any other user it does not requery the data
when the "submit" button is clicked. Here's the code:

DoCmd.Requery qryTableDataSearch

What did I do wrong? Should I be requery-ing the subform instead? Why
would it work for me and nobody else?

-Steve
 
try

Me!MySubformCONTROLname.Form.Requery

make sure you use the name of the subform *control*, not the name of the
subform. sometimes the two names are the same, sometimes they're different.
to get the correct name, open the main form in design view. click once on
the subform (inside of the main form) to select it. open the Properties box,
and click on the Other tab. look at the Name property; that's the name of
the subform control.

as for why your posted code works for you, i couldn't guess; it doesn't seem
to me like it should. (that's the sort of mystery in db development that
makes me roll my eyes, shake my head, and say "whatever!" - and just move
on. <g>)

hth
 
Back
Top