Search results

My criteria is listed in my query. It's: SELECT Master.ProgramName, Master.[Item Description], Master.ItemClass, Master.PropertyClass, Master.AcquiredFrom, Master.Gtag, Master.ItemClass, Master.ManufacturerVendor, Master.ModelNumber, Master.SerialNumber, Master.PartNumber, Master.Quantity...

I want to use a textbox to be the criteria for a subform. How do I got about refreshing the subform as someone types into the textbox? I'm just placing a basic "requery" subform command, but I've placed it in the AfterUpdate, BeforeUpdate, OnDirty, and Change events, and I have to click outside...

Thank you for those examples, LPurvis. I haven't had the chance to look over 'um yet, but I will soon. Those will definitely be of help! Thank you both for your help!

Yes, you guys are right--Like you mentioned, LPurvis, my subform doesn't return null values (which is driving me nuts!). Your example works, but I would still like to learn how to build it in VBA, since I'm not sure how to do it. Will you provide an example or the theory of writing it in VBA?

I'm using a query as the source of my subform. It queries based on what is selected from four comboboxes. The query will display almost all of the records--except for the records that have a null value in one of the fields. There are a total of 449 records in my database. Out of the 449, 152...

Nevermind. I found an old post on the forum and changed my query so that it used "like" instead of using the "=" sign. I used: SELECT Master.ProgramName, Master.[Item Description], Master.ItemClass, Master.PropertyClass, Master.AcquiredFrom, Master.Gtag, Master.ItemClass...

I'm sorry for the many questions, but if I don't apply any criteria, does it mean I need to use separate queries for whether the user selects "*"? I have four separate comboboxes on the my form, and I want them all to be able to choose from all (the "*") or the individual options. In my Query...

Yes, I wanted to know how to add "all" to the criteria. I could add the selection to the combobox, but it doesn't do anything for my subform. My subform gets its values from a query that has criteria in it. It will display information based on what is selected in the combobox. Since it has...

I'm using comboboxes to filter the data shown in a subform. However, I would like to add something like an "any" or "all" to the SQL string. I consider it any because I want it be more of a wildcard. Right now, I'm using: SELECT * FROM Disposition ORDER BY Disposition; Thank you in advance.

I have a subform on my form that is "filtered" by comboboxes. The subform will display records after selecting criteria from the comboboxes, but it doesn't display all the records. After the records are displayed in the subform, I open up the source of the subform, which is a query, and that...

I'm keeping these threads separately because it's different questions :) I have a couple of questions. First, In my tabbed form, I have three comboboxes. I want these three comboboxes to filter the information displayed in a subform (showing the results of a query). The comboboxes are working...

You shouldn't have to log in to download the file--I know you have to wait for awhile for the download link. I uploaded it it Sendspace instead. Please let me know if you have any trouble downloading it.

Yes, those are also the control names for the comboboxes. I uploaded my database to Megaupload (it was too large to attach here), so please take a look at it. I still don't know what I'm doing wrong. . .

I checked it and it looks correct: It says the container name is subMaster. However, I noticed that the Source Object is also subMaster. Should I change that to the query name instead?

Thanks boblarson. In the AfterUpdate code, I have this: Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[ItemClass] = '" & Me.cboItemClass_tab2 & "'" If Not rs.EOF Then Me.Bookmark = rs.Bookmark If Me.Dirty Then Me.Dirty = False Me.tabSpreadsheet.Requery...

I somewhat get a proper display of the data in the subform, but I think it's because I'm forgetting to add in the code or something. I do have something in the Form_Load event. It's: Me.subMaster.Requery I had tried commenting that out, and it's still the same thing. The only other code I...

Ahh. . .gotcha. Thanks for all of your help! It now doesn't have a control source, but it queries the values from the table. For some reason, though, when I click on values in the combobox, it doesn't show anything in the subform now. Should I requery the other comboboxes to update all of their...

I removed the record source from the combo boxes in the spreadsheet view tab and gave the drop-down values as a value list. Do I need to change the AfterUpdate event so that it grabs the text value from the combobox?

I created the combo boxes with the wizard by dragging over the combo box control, instead of dragging over the field list. However, I chose for it to look up values in a table or query. In the AfterUpdate event, I have this for the combo box: Dim rs As Object Set rs = Me.Recordset.Clone...

The control source of my subform is a query. The form runs okay (I'm having problems here and there, but I'm getting my answers!), but if I switch to design mode and then back to form mode, for some reason, it "clears" out the query. I get the error "Query must have at least one destination...