OpenForm Where Clause problems

[darien.watkins]

I have an issue where I am calling a form using Openform.

DoCmd.OpenForm "frmEditIssue", , , "IssueID=" & IDHold

I only have 6 records as of yet, and this will only pull up 1, #5. If
IDHold is equal to anything besides 5 then the form comes up as a new
record.

Darien

 

[ruralguy via AccessMonster.com]

Is IssueID a numeric or text field? If it is text then you need to surround
your value with quotes:

DoCmd.OpenForm "frmEditIssue", , , "IssueID='" & IDHold & "'"

Is IDHold an control or a field or both.

 

[darien.watkins]

IDHold is just a variable for testing now. I've actually fixed this
now...

There was something up with my form, I recreated it and everything
worked. I would figure out what the deal was but I'm just kinda glad
it works now. I think the record form that was linked to the table
was missing the ID.

I don't know,

Thanks for the input.

Darien

 

[ruralguy via AccessMonster.com]

Glad to hear you got it working. Thanks for posting back.