Only Display Filtered Records and No Navigation to Others?

[gyli84]

I have an "OpenForm" macro with a "where" condition to filter the records on a form displaying calls logged at a helpdesk. The user can still use the record navigation buttons at the bottom to view records outside of the filter though. Is there any way to stop this so the button to which the macro is assigned to is pressed some other code specifies that only those filtered records can be viewed and how? I cannot just disable the navigation buttons on the form as the filter returns more than one record.
Also, when the "Calls" form is opened it displays all records but can I filter the records automatically each time it is opened so that it only displays those where a checkbox on it called Completed = 0

Thanks

 

[LonnieJohnson]

Create a query that will limit the records in the RecordSource. Now what they see is what they get. ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[gyli84]

How do you do that? Isn't that exactly what my OpenForm macro does? You can still use the nav buttons to go to records outside the subset returned by the query though.

 

[SyedAqif]

Its strange .....? Normally when u apply where condition it shows like

1 of 3 (filterred)

and u can't goto other records. I dont know but it never happened to me when i used openform with where condition. Please check that the record navigation bar is showing something like 1 of 3 (filterred) or not

Cheers!
Aqif