What's wrong with my code?

[Dalagrath]

Here is my code:

NPC1ACHit = DLookup([ArmorClass],"tblAttackMatrix",[Class] = Forms![frmBattleScreen]![NPC1subform]![ClassBOX] And [Level] = Forms![frmBattleScreen]![NPC1subform]![LevelBOX] And [TotalToHit] = Forms![frmBattleScreen]![ToHitRoll1Weap1])

And my error is:



Please help...

[pbaldy]

This should get you sorted out (the quotes aren't just for show)

DLookup Usage Samples

[Dalagrath]

Ok, I changed it up, and now im getting a "Type Mismatch" error although all of these are numerical values.

NPC1ACHit = DLookup("[ArmorClass]", "tblAttackMatrix", "[Class] = " & Forms![frmBattleScreen]![NPC1subform]![ClassBOX] And "[Level] = " & Forms![frmBattleScreen]![NPC1subform]![LevelBOX] And "[TotalToHit] = " & Forms![frmBattleScreen]![ToHitRoll1Weap1])

[pbaldy]

Your quotes are off. The only thing outside sets of quotes should be form references, and of course the &'s. Down near the bottom of that link is a multiple criteria example that may help.

[Dalagrath]

To be honest, your going to have to show me, because I have tried 3 different ways already and the same mismatch error.

[pbaldy]

Try

DLookup("[ArmorClass]", "tblAttackMatrix", "[Class] = " & Forms![frmBattleScreen]![NPC1subform]![ClassBOX] & " And [Level] = " & Forms![frmBattleScreen]![NPC1subform]![LevelBOX] & " And [TotalToHit] = " & Forms![frmBattleScreen]![ToHitRoll1Weap1])

[Dalagrath]

Well, no more mismatch error, thank you. But it comes up as blank.

[Bob Fitz]

The syntax looks to be correct. So, this may sound like a silly question, but have you actually checked that there is a record that meets the required criteria?

[Dalagrath]

Lol, it's a fine question, kind of like "is it plugged in"?

Yes, when I click the button, it looks at my Level (7), Class (War Priest, which both look at the ClassID), and The number my previous code randomizes.

All three of these have a correlated number attached and should plop out a number.

[pbaldy]

Also, put in a breakpoint so you can make sure the values coming from the form references are what you expect. Can you post the db?

[Dalagrath]

Here is the Database.
http://www.2shared.com/document/8_iDUnuB/ADnD.html

[Dalagrath]

Nevermind, I found out the issue.

I forgot to Bracket the textbox or add a .Value