I have a problem with opening a form.

[Guest]

On the double click event of a button, I have the following code

DoCmd.SetWarnings False

DoCmd.OpenQuery "Qry CustApp", acNormal, acEdit
DoCmd.OpenQuery "List Append", acNormal, acEdit
DoCmd.OpenQuery "List Delete", acNormal, acEdit

DoCmd.OpenForm "Queries Edit form", , , "QueryID = " & Me.QueryID & ""
DoCmd.Close acForm, "menu", acSaveNo

The button is on each row of a continuous form. When I double click the
button it should run the queries and then open the edit form at the record
that I choose.

It has worked in the past but now I get a "missing operator" syntax error
and I can't think why it has doesn't work. The queryID is a number.

 

[Guest]

Hi

Rempve the & "" from the end of the OpenForm line so it reads...

DoCmd.OpenForm "Queries Edit form", , , "QueryID = " & Me.QueryID

Regards

Andy Hull

 

[Guest]

thanks for the message but I still get the same error.

 

[Guest]

Hmmm, weird. The answer that Andy gave should work. If it's a number you
don't need the apostroph so...

Just to do some checking to see where the error is coming from replace the
me.qeuryID with a hardcoded number like say 6 or something like that. See if
the code runs. If it does we know where the problem is...

 

[Guest]

Hi again

Sounds like it may be something in the form being opened.

What's in that form's on open event?

Regards

Andy

 

[Guest]

Hello,

I don't have anything, but I tried Maurice's idea and put in a number and it
works fine.

DoCmd.OpenForm "Queries Edit form", , , "QueryID = 6"
DoCmd.Close acForm, "menu", acSaveNo

 

[Guest]

Hello, I have tried your suggestion

DoCmd.OpenForm "Queries Edit form", , , "QueryID = 6"

It works ok.

 

[Guest]

I have simplified by database a bit and now it seems to be working.

 

[Guest]

I have simplified by database a bit and now it seems to be working.

 

[Guest]

Can you tell us what it is you did? I'm curious as to why the hardcoded
solution did work and Andy's solution didn't. My guess was that his answer
seemed correct. Don't get me wrong I'm glad you got it to work just curious
how you did it (and ofcourse others might benefit from it ;-)

 

[Guest]

What I had was a bit complicated and was more of a design fault than code
problem.

I had two tables and I was using the button to transfer records from one
table to another and then open the form for the specific record number. I am
wondering whether the database was getting confused with the field names.

Now I have simplified it so I have a checkbox and using it to filter records
for various subforms.

 

[Guest]

cheers, thnx for the followup...