Generate Queries Output to Multiple Subform (1 Viewer)

[edisonl]

Hi,

1) My application allows Librarian to search by book name instead of browsing through large numbers of record.

2) In my form, I had 3 other subform-
2a) Borrowers Record.
2b) Books Info (Containing ISBN, Author, Publisher)
2c) Books Detail (Contents, Topics, Pages)

3) So I able to generate a query, but how to output the relavent details to individual subform ?

Thanks (In Advance) for Advice Sharing & God Bless

 

[boblarson]

Each subform needs its own query, you can't "share" one.

 

[edisonl]

Will Try it Out

Hi,

1. Thanks Bob, will try it out.

2. But I aint so familiar with queries stuffs.

3. Is it going to be an update queries?

4. & All the subform link one of the primary field with the main form's field ?

5. How does update queries works ?

Regards & God Bless

 

[boblarson]

No you don't need update queries. It sounds like you could really use a bit of tutorial on Access before moving further ahead. Check this out as it is really good:

Access 2000 to 2003 - http://www.functionx.com/access/index.htm
Access 2007 - http://www.functionx.com/access2007/index.htm

 

[edisonl]

Casade Updates?

Btw, As my forms> subform(1), subform(2) link to main form by book name,


1)Do I need to create anything so that when user update by book name all other table will be able to do the necessary changes?

2)And I heard about casade updates things like that, If I implement it will that change the whole application architecture ?

Thanks & God Bless

 

[edisonl]

Queries

Each subform needs its own query, you can't "share" one.

Hi Bob,

1) Tried my queries it works so far.
2) I tried to fine tune the queries.
3) Will keep you posted

Thanks & God Bless