<div>
You cannot refer to the Column Property of a Combo or List box in a query. But, you can put those values in hidden text boxes and refer to them.<br />
<br />
mx
</div>


You cannot refer to the Column Property of a Combo or List box in a query. But, you can put those values in hidden text boxes and refer to them.

mx

<div>
Try quoting the values:<br />

<pre><code id="code-20-39840632-1">sqlu = &quot;UPDATE Employee_Room_Status Set L_Name = '&quot; &amp; Me.List2Edit.Column(0, i) &amp; &quot;', F_Name = '&quot; &amp; Me.List2Edit.Column(1, i) &amp; &quot;', M_Name = '&quot; &amp; Me.List2Edit.Column(2, i) &amp; &quot;'   WHERE Person_Number = '&quot; &amp; Me.List2Edit.Column(3, i) &amp; &quot;'&quot;</code></pre>
<br />
HTH,<br />
Dan
</div>


Try quoting the values:


sqlu = "UPDATE Employee_Room_Status Set L_Name = '" & Me.List2Edit.Column(0, i) & "', F_Name = '" & Me.List2Edit.Column(1, i) & "', M_Name = '" & Me.List2Edit.Column(2, i) & "'   WHERE Person_Number = '" & Me.List2Edit.Column(3, i) & "'"


HTH,
Dan

<div>
Thank you so much Rey.. It works.. Thank you Dan and Joe for your valuable time..
</div>


Thank you so much Rey.. It works.. Thank you Dan and Joe for your valuable time..

<div>
<div class="content wysiwyg-content">
When I am running this query getting error message run time error 3061, too few parameters, <br />
<br />
sqlu = &quot;UPDATE Employee_Room_Status Set L_Name = &quot;&nbsp;&amp; Me.List2Edit.Column(0, i) &amp;&nbsp;&quot;, F_Name = &quot;&nbsp;&amp; Me.List2Edit.Column(1, i) &amp;&nbsp;&quot;, M_Name = &quot;&nbsp;&amp; Me.List2Edit.Column(2, i) &amp;&nbsp;&quot; &nbsp; WHERE Person_Number = &quot;&nbsp;&amp; Me.List2Edit.Column(3, i) &amp;&nbsp;&quot; &quot;<br />
<br />
Immediate window &nbsp;showing: <br />
sqlu = UPDATE Employee_Room_Status Set L_Name = Mathew, F_Name = George, M_Name = T &nbsp; WHERE Person_Number = 2323 <br />
<br />
Please help
</div>
</div>


When I am running this query getting error message run time error 3061, too few parameters, 

sqlu = "UPDATE Employee_Room_Status Set L_Name = " & Me.List2Edit.Column(0, i) & ", F_Name = " & Me.List2Edit.Column(1, i) & ", M_Name = " & Me.List2Edit.Column(2, i) & "   WHERE Person_Number = " & Me.List2Edit.Column(3, i) & " "

Immediate window  showing: 
sqlu = UPDATE Employee_Room_Status Set L_Name = Mathew, F_Name = George, M_Name = T   WHERE Person_Number = 2323 

Please help

run time error 3061 vba - msaccess

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

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.