Recent content by guanfl

As Brian mentioned some posts are missing. I managed to solve the issue though at the same time uncovering another problem. I managed to accomplish this by including and expression like "FIRST(tbloption.parentID) AS ...." on the ParentID field. Just to shed some light; attached is what i...

No error message. Just not getting the results i want. I want to apply the "DISTINCT" function to the field 'stocktransid'. I believe the solution is including "DISTINCT" somewhere in the FROM statement but i'm lost with the syntax of writing it.

Hi all, I'm having difficulty with the syntax in this query to remove duplicate data for the field "StocktransID". Any help is greatly appreciated. SELECT DISTINCT tblStockTrans.StockTransID, tblItem.Brand, tblItem.Category, tblItem.SubCategory, tblItem.Model, tblItem.Description...

The form is a subform in a navigation control tab. Though i tried creating a test textbox on another tab with another listbox and it works. I'll try recreate the form..i just don't see what the issue is.

Rowsource of listbox is a query and is producing a list.. Yeap bound column 1 = column (0), tried moving the bound column and also column(x) accordingly.

Definitely spelled correctly. Renamed the listbox just to be sure...recreated etc etc. I dont understand..I think my form is cursed..lol.

Hi, any reason why =listboxname.column(0) in the control source of a textbox will give me the value "#name?" ? I've used it successfully on another form..but for some reason its not working for me.

Awesome! thanks MSAccessRookie. Don't you just hate it when the solution is so simple.

1. User selects a value from combo box 2. If value of combo = x then rowsource of listbox is "that query" The text in txtsearch basically utilises the query to dynamically change the results of the listbox with the "Like *txt*" clause. The code for the txtsearch change event is: 'Create a...

Doubt it there is a requery action on txtsearch change. Like i said it works fine when i copy and paste the query directly into rowsource. Its just that in vba the like clause isnt biting. Maybe it has something to do with "*" in vba? are wildcards recognized in code?

Yeap it has the desired effect when i just copy and a paste the original code directly into the listbox rowsource and a query in sql view Original code: "SELECT tblProducts.ProductID, tblProducts.ProductName, qryTotalProducts.Qty FROM tblProducts INNER JOIN qryTotalProducts ON...

Thanks for the reply. Its showing data but the likestr has no effect on the query.

I am trying to populate a listbox through its rowsource but i'm not sure if my syntax is right for the like clause. Not showing any results: me.list.rowsource = "SELECT tblProducts.ProductID, tblProducts.ProductName, qryTotalProducts.Qty FROM tblProducts INNER JOIN qryTotalProducts ON...