you can't go to this specific record

G

Guest

I have a criteria form and a main form. in the criteria form, I created a
button to correct all criteria and build a where statement. then I use
openform with where statement to open my main form. I got " you can't go to
this specific record." I have no idea how to look into this message. what I
tried to do is to find the record then populate to the main form. The coding
is as...
docmd.openform "fm_main",acnormal, , mywhere
mywhere is string for the criteria.

Any idea about this error msg?
MC


--
 
S

strive4peace

do you have a listbox or combobox control on the form you
are trying to open that gets its criteria from a form control?

what is an example of "mywhere" ? Are you referring to a
field that is on your form? in your form recordset?

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open form with specific criteria 3
Closing Form causes a requery? 3
Lookup Mod Function Code Needed 1
File in use error 5
Parameter query problem 1
Access Command to run access, open to specific form and specific record 1
Including blank fields in results when filtering a report 1
Opening form using 2 criteria 9

Top