using a parameter query to populate a report. 1

[Klepdog]

I created a form "SelectIndividualTaskList" to control what is shown on a report. The control is an unbound combobox (NamesList) that is based on a query from the table "Names1" which is joined to three other tables. I also created a hidden unbound field (SelectedIndividual) that =NamesList after update. I designed a select parameter query that gathers data from table "Names1" and "TASKS". The query "SearchNameTaskQual" uses [Forms]![SelectIndividualTaskList]![SelectedIndividual] as the control source to search for all records for that individual to be used in a report. The report "IndividualTaskQual" has the "SearchNameTaskQual" query as the control source. My problem comes when I try to run the report. I get the error "cannot open table. table in use by another object/user." Could I be running to many queries a one time (the one for SelectIndividual and the other for the parameter query) both use the same table (Names1). The report works if I bypass the form but manually enter the last name for the parameter query. The combobox also updates the hidden field correctly. I am usaing Access 2007.

Thanks
Don

 

[lameid]

This is the result of locking. It sounds like the database is set to exclusivley lock records instead of shared locks. I am not sure where the settings are in Access 2007 but a quick search should turn it up. In 2010 which is likely similar to 2007, I think you would hit the file tab / group on the ribbon and then select options. On one of the tabs in that window, should be a setting to control locking. I only have 2003 handy at the moment which IS different.