<div>
<br />
stupdate = &quot;update tbl_transactions set status_id= 1 where DBNnumber = &quot;&nbsp; &amp;&nbsp;rs![DBNNumber] 
</div>



stupdate = "update tbl_transactions set status_id= 1 where DBNnumber = "  & rs![DBNNumber]

<div>
<div class="content wysiwyg-content">
I have a really simple issueand I think I'm just tired....I get data mismatch error....my Transaction_ID is a number...<br />
<br />
stupdate = &quot;update tbl_transactions set status_id= 1 where DBNnumber ='&quot; &amp;&nbsp;[rs]![DBNNumber] &amp;&nbsp;&quot;'&quot;I <br />
<br />
I PROMISE 500 points and an A
</div>
</div>


I have a really simple issueand I think I'm just tired....I get data mismatch error....my Transaction_ID is a number...

stupdate = "update tbl_transactions set status_id= 1 where DBNnumber ='" & [rs]![DBNNumber] & "'"I 

I PROMISE 500 points and an A

Data mismatch Error: REALLY EASY

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.