Filter records in forms

[Guest]

hi all,

I'm currently facing a problem in form. It was required to allow user to
enter any criteria in any fields, and those records meet the criteria will
have all the records details in the same screen... Is it possible?
I had try on filter by form, however i need to view on all other records in
just one screen just like having a subform. But is it possible to do so,
where I'm just dealing with the only table?
Hope it is understandable!
Thanks in advance

Regards
Green

 

[Guest]

you can create a form, the main form, display it in datasheet view all the
data.
create another form with all the field you want to filter with, in the OK
button you can assign either a filter to the mainform or use code and assign
a new RecordSource to the main form.

Forms.[FormName].RecordSource = "Select * From MyTable Where ...."

 

[Guest]

Hi Ofer,

I was able to do the main form... However i'm unsure with the second part,
where you say "in the OK button you can assign either a filter to the
mainform...."
Where can I find the "OK button"?
Sorry I'm rather new with access...

Regards
Green

you can create a form, the main form, display it in datasheet view all the
data.
create another form with all the field you want to filter with, in the OK
button you can assign either a filter to the mainform or use code and assign
a new RecordSource to the main form.

Forms.[FormName].RecordSource = "Select * From MyTable Where ...."

hi all,

I'm currently facing a problem in form. It was required to allow user to
enter any criteria in any fields, and those records meet the criteria will
have all the records details in the same screen... Is it possible?
I had try on filter by form, however i need to view on all other records in
just one screen just like having a subform. But is it possible to do so,
where I'm just dealing with the only table?
Hope it is understandable!
Thanks in advance

Regards
Green