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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stop new record entry while filter is on?? 5
Not all data in fields is showing up in query 5
Need help setting up stLinkCriteria for multiple values 1
Data entry creating duplicate rows in table 3
Choosing a form’s record source 3
Displaying all of the fields for a record chosen in a combo box 7
Filtered records as source for appending records to a table 3
Access Access 2010: Activating controls in a form after filter by form 0

Back
Top