在Access中填充ListBox [英] Populating ListBox in Access

问题描述

Hello All，


我目前有一个订单，当选择并保存记录时，这应该出现在下面的列表框中。我可以添加这个，但同时我从前一个订单中下的订单将显示在同一个列表框中。当我只想要当前正在下订单的记录时

这就是我正在使用的......

Hello All,

I currently have an order form, when a record is selected and saved this should appear within the listbox below. i could get this to add but at the same time the order that i have placed from the previous order would display within the same listbox. when i only want the record from the current order that is being placed
This is what i am using...

展开 | 选择 | Wrap | 行号

推荐答案

Hello All，


我目前有订单，选择并保存记录，这应该出现在下面的列表框中。我可以添加这个，但同时我从前一个订单中下的订单将显示在同一个列表框中。当我只想要当前正在下订单的记录时

这就是我正在使用的...


Private Sub populateListbox（）

Dim strSQL As String

Dim strcustomername As String

Dim rstLoans As DAO.Recordset

strcustomername = txtorderno.Value


设置rstLoans = dbase.OpenRecordset（" tblorder"，dbOpenDynaset）

lstOrderDetails.RowSource =""


strSQL =" SELECTtblorder.orderno，tblorder.ProductID1，tblord er。 [Clothingtype1] QUOT;

strSQL = strSQL& FROM tblorder;



lstOrderDetails.RowSource = strSQL

End Sub


这是我目前正在使用的代码。我被困了plz halp !!!!

Hello All,

I currently have an order form, when a record is selected and saved this should appear within the listbox below. i could get this to add but at the same time the order that i have placed from the previous order would display within the same listbox. when i only want the record from the current order that is being placed
This is what i am using...

Private Sub populateListbox()
Dim strSQL As String
Dim strcustomername As String
Dim rstLoans As DAO.Recordset
strcustomername = txtorderno.Value

Set rstLoans = dbase.OpenRecordset("tblorder", dbOpenDynaset)
lstOrderDetails.RowSource = ""

strSQL = "SELECTtblorder.orderno,tblorder.ProductID1,tblord er. [Clothingtype1]"
strSQL = strSQL & "FROM tblorder;"



lstOrderDetails.RowSource = strSQL
End Sub

This is the code that i am currently using. i am stuck plz halp!!!!

''我不知道具体细节，所以我可以概括一下：

展开 | 选择 | Wrap | 行号

''我不知道具体细节，所以我可以概括一下：

展开 | 选择 | Wrap | 行号

我还有问题，这就是我输入的内容填充框

im still having problems, this is what i entered within the populate box

展开 | 选择 | Wrap | 行号

这篇关于在Access中填充ListBox的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！