Filter records in forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

'green' - 10 May 2005 02:26 GMT

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

Reply to this Message

Ofer - 10 May 2005 23:50 GMT

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,
>
[quoted text clipped - 9 lines]
> Regards
> Green

Reply to this Message

'green' - 11 May 2005 02:11 GMT

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.
[quoted text clipped - 17 lines]
> > Regards
> > Green

Reply to this Message