Using a Input form also as search form

[jurgen]

Hi,

How can I use an the same access form to input data in the table and also use it to search data for the table with some conditions,

Something like the filter button, only thing is no one may use the filter button, it has to be programmed...

can someone give me some advise


Regards


Jurgen

 

[braindead2]

Remove the froms record source then set the source based on a query using the fields