Re: The command button on my forms doesn't work, any clues why?



Mike, it's not clear how you are approaching this.

Forms in Access 2007 have a FilterOnLoad property.
Set this to No. If it's set to Yes, it may load with an old filter applied, so the record you want is not in the form.

Let us know if that makes a difference. If not, provide more detail on how you are passing the value from one to the other.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MIKE" <MIKE@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:88577F85-A8C3-4873-9A73-F9B17E899F8D@xxxxxxxxxxxxxxxx
did you ever resolve this problem ? ?

i have also converted to access 2007 from access 2003 and have encountered
the same exact problem you describe . i used the command button
extensively to transfer control from a primary form to a sub form with
specific detail records. this procedure no longer functions properly using
access 2007.

if someone has responded with a solution, kindly refer me to that info

thanks mike

"GHouse" wrote:

I'm trying to link one form to another by a reference number which is in both
forms. I've used the command button wizard which takes me to the other form
but not to just the records I want to see. This worked fine in my 2003 access
database.

.