Drop down in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a db with asset tracking information for server hardware. One of the
pieces of information, which is also in it's own table, is the applicaion
running on the server. I want a query where I can select an application from
a list and have it return the servers that match. I have a query right now
where it prompts to enter an application and then after you type it it gives
the results. The problem with having to type it is differences in spacing,
spelling and just knowing what exactly the application is called. Is there
any way to make it so I can select from a list?

Thanks.
 
On a form use a ComboBox or ListBox to select from.
In the query use criteria --
[Forms]![YourForm]![YourComboBox]
OR
[Forms]![YourForm]![YourListBox]

Use a macro or event in your ComboBox or ListBox to open the query.
 
Where do I put the macro? I've go the list box, query and report all set. I
have a macro created to open the report based off of those. I tried putting
the macro in the on click or on change properties of the list box and when I
test it I get an error that it can't be modified.

KARL DEWEY said:
On a form use a ComboBox or ListBox to select from.
In the query use criteria --
[Forms]![YourForm]![YourComboBox]
OR
[Forms]![YourForm]![YourListBox]

Use a macro or event in your ComboBox or ListBox to open the query.


langirl77 said:
I have a db with asset tracking information for server hardware. One of the
pieces of information, which is also in it's own table, is the applicaion
running on the server. I want a query where I can select an application from
a list and have it return the servers that match. I have a query right now
where it prompts to enter an application and then after you type it it gives
the results. The problem with having to type it is differences in spacing,
spelling and just knowing what exactly the application is called. Is there
any way to make it so I can select from a list?

Thanks.
Click to expand...
Click to expand...
 
What is the entry you used in the On Change properties?
What was your macro command and argruments?

langirl77 said:
Where do I put the macro? I've go the list box, query and report all set. I
have a macro created to open the report based off of those. I tried putting
the macro in the on click or on change properties of the list box and when I
test it I get an error that it can't be modified.

KARL DEWEY said:
On a form use a ComboBox or ListBox to select from.
In the query use criteria --
[Forms]![YourForm]![YourComboBox]
OR
[Forms]![YourForm]![YourListBox]

Use a macro or event in your ComboBox or ListBox to open the query.


langirl77 said:
I have a db with asset tracking information for server hardware. One of the
pieces of information, which is also in it's own table, is the applicaion
running on the server. I want a query where I can select an application from
a list and have it return the servers that match. I have a query right now
where it prompts to enter an application and then after you type it it gives
the results. The problem with having to type it is differences in spacing,
spelling and just knowing what exactly the application is called. Is there
any way to make it so I can select from a list?

Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top