Search results

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...

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...

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...

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...

I apologize for having so many questions today! I have a form that has tabs in it with record source as the table "Master". The first form uses the fields from the Master table so that the user can input data into the table. The second tab is used to query the existing data in the Master table...

I'm trying to create a form and a its child subform so that when you select a value in the combo boxes in the main form, the records corresponding to the choices in the combo box will show in the subform. However, I'm running into problems with the first combo box. If I make any choices from the...

I have a form (frmInventory) and it's subform (frmInventorySub) in my database. I have three combo boxes on frmInventory, and I want to use the three combo boxes (cboProgramName, cboItemClass, cboPropertyClass) to filter information from the main table (tblInventory). The subform is basically a...