Use same query for different forms at the same time?

[geralf]

Hi!

Can I use the same query at the same time in different forms or in a form and create a recordset in VBA using a query?

Thanks in advance!

 

[KenHigg]

Should be able to. Have you tried this somewhere and had problems?


kh

 

[geralf]

Thanks for your reply.

I've made a multi user db that has a split setup (FE/BE). I'm redoing the db now, due to some structural and table changes. I've always made new queries as a recordsource for new 'items' in Access, even if I have a query that could be used. This of course increases the numbers of queries. I would like to know if I can use the same queri simultaneously (e.g - open form and making a recordset in a VBA module based on the open form's query.

Thanks again.

 

[KenHigg]

If you are just viewing records in one place or the other, it shouldn't be a problem. But if you want to be able to have a form open where you can edit records, then you may have a problem if you try to update records with ADO at the same time.

kh

 

[geralf]

Thanks for your reply and interest Ken

I think I'll use a new query for each source, just to be on the safe side. It's also more flexible then. I have to come up with a good naming sceme, so it's easier to see where each query is used.

Thanks again.