How do I password protect a subform within a main form? I have a database that tracks project information I only want only certain people to access the edit/view all data subform. Everyone can access the enter new project subform which doesn't allow editing of existing records.

This one must be simple, but I can't find an explanation.
In Access 2000, I have a subform which is displayed as a datasheet; a grid.
I'd like to put a button at the end of each row to open another subscreen.
So far, when I place a button on the form, then open it as a datasheet, ...

I have construted a form to edit records in a table.  I use an unbound combo
box to navigate through the records.  The combo box LimitToList is set to
Yes.  If the value entered is not in the list, I want to be able to add the
record to the table.  I have tried the NotInList ...

I have post this question several days ago, but sadly there is no
reply...Would anyone please follow up? Please !!!
I have a inventory control database here. For the products, on the
"products" form

Is there a way to lock the fields in a record, for example
if status = true then....
I've tried me.allowedits = false, which people recommended, but this doesn't seem to work.

I am using   Expr1: InStr([Type Member Numbers separated by
commas,Blank=All],[MemberNumber])  to allow the user to bring back a list of
Members based upon ID. I got this either from MS Site directly or off of the
discusssion group.

I have a table and form that records the username that entered the record
via the currentuser() function.
I would like all user to be able to add records, but only allow the user
that entered the original record to be able to edit it.

Is it possible to have a report that displays 2 lists of records? the
perfect result would be a report that contains a sub-report.
and I cannot put a query that selects both of the tables otherwise, I'll
have multiplication of result

I have a form that has subformA. On subformA I have 2  
cmdbutton that makes visible/invisible 2 subforms on
subformA.  I use visible/invisible due to space
limitations.  Is there a way to make a these 2 sub-

I've seen a tons of posts on this problem and none of the solutions have
helped.
Here's the deal,
Clicking the new record button on the navigation buttons bar works fine.

I have a form that lookup by account# (txtAccount) then get values linked
with this account in shipto combox (comboshp). I like to get the record
after user choosing shipto. how would I do this in after update.
the rest of data of this record in one of my query which includes

Hi. I am using Access 2002 in XP. I have a subform set
into a form which sits on a Tab control page. I want to be
able to present the subform records sorted first by one
field and then within that, by another field. Both fields

I'm trying to create a database in which there is only one table that
contains all of the payables for a company. All the payable invoices have
primarily 3 fields: 'type of cost', 'date due' and 'amount'. The object of
the database is to obtain a printout of expenses categorized by ...

I have an application that uses two databases. One new and one old. It works
as it should with all references exept for some combo boxes.
If I use a combo from the new database, it is possible for the users to find
a product by choice. This is when the product, supplier and product ...

Scenario:
I have got a form with a subform, the subform shows all records in a table.
On my main form, I have three unbound listboxes where users can select
"optional search criteria".  When the user clicks on a button, a filter