Recent content by antidote

Right, but if i set it to visible in the query, that field will show up in my list box, and I do not want that field in my list box.

Hello... sorry to dig up an old thread but I was wondering if you can use this method to display fields from a query where some fields are not "shown" I have tried the above method, but when I put my index on 8, there is no data since the field is set to not shown in the query. Any ideas?

Can anyone please steer me in the right direction? thanks

SEARCH is my form. SUBSEARCH is my datasheet view subform. SUBSEARCH2 is my second subform where i wish the description to be.

I am not exactly sure where I would put that code. Here is the code in my subform right now. Thank you for your help, it is greatly appreciated. Option Compare Database Private Sub cmdCancel_Click() DoCmd.Close acForm, "SEARCH" End Sub Private Sub cmdOK_Click()...

Hello. I have a form which I am using to create a pseudo search engine for my database. Users enter search criteria via unbound text boxes. The information the user enters is sent to a query to search my database for records. results are displayed in a datasheet view in a subform. (which is...