I need my query to ask me

[Abbosy]

Hi there guys
I'm trying to set a query with 6 fields.
My question is: Is it possible that the query shows me a combo box to select what is connected to this data.

Example fields:

HospCode; HospName; Dept; ModName; SerialN; DatInst

I'm looking to select name of a hospital from "HospName" from a list box. If no, then at least to write the name and the rest I'll get it associated with the name.

Then I need to know if I can put this in a form so the form asks same criteria?


Lots of thanks

 

[Cronk]

On your form, have combo boxes which have the row sourced based on lookup tables containing the options you want available. You can base a query that when it runs, uses the values selected.

For example, in the HospName field in the query use in the criteria
Forms!frmYourFormName!cboYourComboName