Form error

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I am getting an error, and I believe I understand what it is saying, but I
guess I looking for a fix or workaround. Basically, I have a main form with
3 subforms. Each subform's data is a seperate query. Those query's filter
data from an underlying table, they pull 3 sets of different data. When I
open the main form, I get an error saying the table is already open
exclusively by another user....... The first subform display's fine, the
other two are whited out. I assume it access is getting mad because all 3
query's are referencing a single underlying table. I like the 3 column view
to pull 3 different sets of data. The subforms are used for display only, no
editing, i tried to lock them. Any help? thanks for any suggestions.
 
Hi Chris,
one approach is to use a single subform that shows all the data from the 3
subforms.
Could you format the subform into columns that looks like 3 lots of data?

Another approach is to use a report instead of a subform.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Jeanette, thanks for your response. I had also thought about using 3 macros
on the on open event, to run a update table query based on the 3 filters
needed, then using those as the record sorce for the 3 subforms. However, I
have been trying to get away from doing this kind of stuff, to have more
streamlined databases, since I already have the info in there its just a
matter of how i want to pull it out and display it. Your suggestion of
columns on subform's was interesting. I have looked before, but can you have
multiple columns on a single form, using different filters of data. I dont
have to use 3 query's, thats just what i used to filter the data. I do have
3 different sets of data to pull, could be used with filters, its not that
complex, i just didnt' know you could do that with one form and multiple
columns. How would i go about doing that? thanks again.

Chris
 
Chris,
it was just an idea - without knowing the details of your table, the fields,
the queries and the information you want to display it's hard to say.
It also depends on how well normalized the data is.
Maybe a tab control with each query on a different page of the tab control
would help.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Back
Top