Query not returning certain data....

[mgillespie21234]

Scenario: I have 2 tables, one called Location and the other called PC Inventory. They both have columns called sites. The query is set to search both tables by site name and return the PC's at that site that match the search criteria.

The search form has a drop down menu with all the site names. When you choose a site name from the last, the after update event does a re-query to a subform on that same form. The source object of the subform is set the query.

[Forms]![PC Search]![Combo6] - this is the criteria on the query that point to the drop down menu.
--------
Private Sub Combo6_After Update()
Me.Child19.Requery
End Sub

This is the requery that point to the subform (child19)
--------

The problem is that some selections from the list don't return any results to the subform. But there is clearly records that meet the criteria in the table. Example: ABC @ Maryland returns all the PC's at the site. DEF @ Maryland doesn't return any PC's at the site, but there are records with that site name.

Even if go into the table copy the site name that isn't working and enter into the search field it doesn't return the results. Been banging my head for 2 weeks on this, any help is greatly appreciated. Please, if you need any more information or have any questions, I will be happy to provide them!!!

 

[Mihail]

The query will show you only that record where the location (Site) is the same.

Maybe I can tweak your DB if you will post it (Access 2003 or 2007) but your approach is not good. You should have a separate table with sites. (at least)

Take a look here:
Database Normalization and Table Structures - Microsoft Access / VBA

 

[mgillespie21234]

Unfortunately, i cant post the DB as it has sensitive data.

The location table is the kind of the site table. It holds all the individual site information.

I have a column called site in each table, location and PC inventory.

 

[Mihail]

Unfortunately, i cant post the DB as it has sensitive data.

For sure you can.
We need only few records for tests, so you can easily to replace sensitive data with something non-sensitive.