Search results

Thanks for the help. I have fixed the issue. I recreated the form with the same data and it appears as it has been fixed...! Must of been a corruption of sort :confused:.

Thanks for the reply! I have tried creating a new database and importing the objects... Still the same issue :banghead: It is a split form. When I turn the split form off it seems to work fine... the issue seems to be linked to that somehow? Is that possible?

I am having troubles with filtering on my form. When I apply a filter to one of the forms controls it comes up with: The object doesn't contain the Automation object 'TagStatus.' You Tried to run a visual Basic procedure to set a property or method for an object. However, the component doesn't...

ok. Thanks! I will come back if I am having issues after I fix the current problem at hand.

Thanks for the reply guys, I have some work ahead of me. To simplify the query: Table: ITR1 Status1 ITR 2 Status 2 EI-28-01 Received EI-28-02 Not Started EI-15-01 Completed EI-15-03 Received EI-13-03 Added EI-15-01 Not Started I want to Count the...

Hello, I am wondering if there is any way to use multiple count functions in a query with their own individual filters without affect the others? For example: SELECT [E&I Table].System, [E&I Table].DeleteRecord, Count([E&I Table].[Status#1]) AS [CountOfStatus#1], Count([E&I Table].[Status#2])...

event procedure on after update and embedded macro on change... is this a bad thing? Thanks, Wade

cboTagNumber is used with an macro after update to search for record, Combo133 is used with a macro on change to run a query to filter the results in the records... not sure if this would have an effect on that? Thanks again for the help

It still remains filtered? Could it be something else that is causing it? When you exit and go back in, it goes back to default containing all the values under [Tag Number]. Thanks, Wade

Thanks for the quick reply! It still has the same result. The list remains filtered when the Combo133 is cleared?

Hi all, I am fairly new with Access and VBA and am having troubles with the following. I filter a second combo box "cboTagNumber" with the first combo box "Combo133". The problem is when I clear the first combo box, the second combo box remains filtered. Is there an easy way to clear this...