Filtering New Records

[brian]

I am creating a quoting program for our salesman. I need
a way to filter the records so they only have access to
the current record being filled out.

On FormLoad() and through a command button a new record
will open. I only want the salesman to have access to
the current record. Throuh another menu option salesman
can go back and edit previous quotes.

I turned off the record navigation scroll bars but if you
have a scroll mouse you can scroll and have access to
previous quotes.

Thank You

 

[Tim Ferguson]

I am creating a quoting program for our salesman. I need
a way to filter the records so they only have access to
the current record being filled out.

Base the form on a query like

SELECT * FROM MyTable
WHERE OrderNumber = 10886

you can set this in the Form_Load procedure like this:

me.recordsource = strSQL
me.Requery

HTH



Tim F