Search results

It worked after I changed my form a little bit. Thanks for the help! One question how had would it be to take my critiria form and put combo boxes on it, would it require a lot of programming?

What I am doing is using the frm Criteria to select the information that I would like to search for, this frm is tied to tblDevices Query. I would like to have the query output the query into frm frmbasedonqry, but it keeps outputing the information as a spreedsheet. Is thier a way to link the...

I have a form with the query as the record source (frmbasedonqry)but it is not working. Here is the database that I am trying to create this in.

I am wondering how you can output your query into a form. I have a form to select the information the end users is looking up, which refers directly to the query but how can I tell the query to place the results into a form view?

I am a little lost on how to get the combo box to work correctly. I am tryinfgto use a junction table to select what the end-user would like to search(IP, MAC Address, or jack number) and then they will type in the information and query the database for that device. I am thinking, thier will...

What I am trying to do is create a database that will enable me to track what devices(Computers) are connected to a certain switch port on a swtich. So, when a person calls into change thier computer out I can look up thier computer by the mac-address to know what swtich port needs to be unlocked.

ScottGem thanks, that makes more sense than having everything in one table. I will try that to see how it works out.

davidbodhi after looking through all the examples. I really do not know if it is possiable because everything that I have is in one table. Is it possiable to have cascading combos with just one table? Here is a copy of what I am trying to do. In forms thier is a form called locate, I want...

I am new to access and trying to create a combo box that will enable the end-user to select a field in a database. Then type in the information in a text box to search for information in that field. For example: end-user can select MAC-Address and then type in the MAC-Address number to locate...