Search with multiple fields result from query

[manishmeta]

Hi,

I want to make a form which will allow me to get data from a query and search using 3 fields parallely.
Attached the database in 2010 format.
password of the db is "nolimit".
The query PTM & Equipment should be bound with the form and
if I enter month, PTM and equipment need rest 2 fields displayed.
Like choosing the above 3 fields from the drop down , the next 2 text box should display the rest two fields.


Thanks in advance.

 

[JHB]

I want to make a form which will allow me to get data from a query and search using 3 fields parallely.

Then I think you should start doing the form and if you have problem with a particular thing then ask, but I don't think anyone here will make the work for you.

 

[manishmeta]

I am really sorry for that.

The form I am submitting with same password.
The form Equipment needs to be used for the purpose.
Choosing 1st three items next two should follow.
Also, I dont need the repeated items shown in dropdown.

Thanks

 

[JHB]

Also, I dont need the repeated items shown in dropdown.

Then use "DISTINCT" in the query like below:

SELECT DISTINCT [PTM & Equipment].[Day By Month]
FROM [PTM & Equipment];

I need to ask, are you trying to make a search form, (because then it is wrong designed.)?

Choosing 1st three items next two should follow.

...
if I enter month, PTM and equipment need rest 2 fields displayed.
Like choosing the above 3 fields from the drop down , the next 2 text box should display the rest two fields.

I can't follow you here, which fields/controls should be shown?