Microsoft Access Experts only...SQL Coding help!!!?

Currently there's a form (1st form) that if you select a user ID from a combo (drop down box) it displays in a data table the person's machine, IP address and Domain name and if you enter one and click “refresh” it updates the table with the right info. I’m trying to create a similar type of form (My form) where you enter an IP Address in the drop down box and it will show all the User IDs that have used that IP Address in the data table. For some reason, the data isn’t being displayed in the data table even though I know I have the right select query written…





1st form:





SELECT qryUniqueUID.USERNAME FROM qryUniqueUID;





My form:





SELECT qryIPAddress.ADDRESS FROM qryIPAddress;








In the combo box’s properties, there are many tabs (Format, Data, Event, Other, All). And the location where that code above is written is in a row called “Row Source” in Data tab.





Any advice would be appreciated on what to do…thanks.

Microsoft Access Experts only...SQL Coding help!!!?
What is your "Row Source Type" set to? Are there any column count or width attributes set? When you say "the data isn't being displayed," are you getting an error? Does the combo box only show one blank entry? Does it show a long list of blank entries?





Are you pulling this data from a query? Do "qryUniqueUID" and "qryIPAddress" have basically the same setup? (If they are queries, how many tables do they pull from?)