Question Creation of a Drag Box

[Mahendra]

Hello,

I have multiple search boxes in my form like Name, Pages, Year, Email, University etc....

Instead of displaying all the search boxes with the names I wanted to create a dragbox for those search boxes.

Dragbox (Should contain all the names of the search boxes)

If we select "Name" in DragBox then we can search for Name

If we need to add another DragBox. Then there should be a button named "Add Another Filter". If we click on this button then another dragbox needs to be displayed and this time we can select "University" and search for the relevant records.

I don't know how to do this. Can any one help me out in doing this or else just ping me out with a relevant video on this please.....

Let me know if you are not clear with my requirements.

Thanks.

 

[spikepl]

What is Dragbox?

 

[Mahendra]

What is Dragbox?

It is a combo box whcih contains the name of the columns.

 

[CJ_London]

In the rowsource of your combobox put the name of your table.

In the RowSourceType, select FieldList

 

[Mahendra]

In the rowsource of your combobox put the name of your table.

In the RowSourceType, select FieldList

Thanks. It worked for some bit.

Am Novice to MS Access. I ahd attached my project with this post. Could you kindly have a look into this and let me know how to achieve my requirements.

I mean there should be a text box for that dragbox. We need to enter anything in that text box and then we need to press on search.

Could you kindly give me hints for this please.

MFORM is ths main form

and Main is the main table in the attcahed file