Highlighting record from form to start query

[John Key]

Hello

I am just starting out with Access, so apologies if my question sounds
stupid.

My question is, if you have one table presented as a form and you want
a single record selected or hightlighted by row rather than filtering
and to then query that single record against another table, how do you
do that?

For example, you have a table of bookclub members and further tables
of types of books they like and a list of all books available. The
membership list is presented in a datasheet type form and you want a
single member selected by highlighting the row to begin a query to
make a reading list history table. So far, my efforts have only
resulted in the whole membership list being exported to the query
rather than the single person.

Obviously, I could do a parameter query on the members list and have
it continue into the book preference query, but I am looking for
something that just highlights the row and exports the single record
to the preference query.

Or am I missing something simpler that I could do?

Thanks in advance.

John

 

[tina]

i suspect that you're trying to do something that *is* possible, but simply
using incorrect nomenclature to try to explain it. you described three
tables: a bookclub-members table, a list-of-all-books table, and a
types-of-books-each-member-likes table. you also talked about *making* a
"reading list history" table.

let's skip the database part of this issue for a moment. can you explain in
real-world, layman's terms how members are related to books, and exactly
what you want to keep track of?

hth

 

[John Key]

An area can have several bookclubs sharing books, which can then be
shared amongst its members. Apart from contact details, you want to
keep a history of books read or discussed by a member, but also allow
them to choose books they may like or select by criteria (biography,
history, fiction, etc) and see who has copies of the book.

The first table would be the bookclub's members (name, address, club,
etc and preferences linking to the criteria table), the second main
table is the books available cross-referencing to who has them.

One form will allow me to check on a member's reading history or books
discussed, another will allow them to use their name to access a
reading history or a recommendation list. A member's form would have a
subtable of their reading history.

However, what I am looking for is a simple form which presents the
available book titles and description in a datasheet table form where
clicking on the row and 'Search' will specify only that single record
as the one to be used in one or more different queries.

I was thinking of this form as a query in itself and the highlighting
of a row would be a be a validation point before clicking the 'search'
command to filter that single record to the next form which presents
several options to search under one or more different criteria.

Hope that makes sense.

Thanks

John

 

[tina]

to refer to a control in the Current record (in a Continuous or Datasheet
view form, that's the record that is highlighted or "has the focus") in a
form, in a query's criteria, the syntax in the criteria row of the query
design grid would be

Forms!FormName!ControlName

hth

 

[John Key]

That sounds like the one.

Many thanks

John

to refer to a control in the Current record (in a Continuous or Datasheet
view form, that's the record that is highlighted or "has the focus") in a
form, in a query's criteria, the syntax in the criteria row of the query
design grid would be

Forms!FormName!ControlName

hth

 

[tina]

you're welcome

That sounds like the one.

Many thanks

John