Filtering Record Sources

  • Thread starter Thread starter Owen Wilson
  • Start date Start date
O

Owen Wilson

Hi,

I have a database that handles data for several projects
at once. Each project has its' own unique Job Number. I
would like to allow each user to filter the database so
that it only displays the data pertaining to thier job.
I have built a query that does that, but then they can't
add any new records or edit the existing ones.

Is there a way to filter it so all the forms show data
for specific jobs and allow edits and additions?

Thanks,

Owen
 
Owen,
You can do this through a query you just have to make sure that your query
is updateable. Some things that can make a query "not updateable" are the
joins, if it is not a select query, if you are joined to another query that
is not a select query, etc.

Hope this helps.
 
Back
Top