|
Pete
Your initial post did not include
ClientID which I suppose belongs to a third table. Then I think more information
is needed for the members to help you better. How many tables are involved in
this and what are their relationships? Until this information is available it
may be difficult to figure out how a solution may be achieved.
Good luck
Liveson
----- Original Message -----
Sent: Thursday, October 13, 2005 12:56
PM
Subject: [AccessDevelopers] Re: Forms and
Subforms
Liveson,
Thanks for this.
The forms cannot be
based on tables as information comes from
multiple tables.
I have a
query for the main form which just returns Surname, PenName
and
ClientID.
The subform has a query that includes AuthorID which is the
link
between the two queries/forms.
The problem is that I need a
dropdown list on the form that shows
all the Surnames and another for the
PenNames. When either of the
entries in the lists is selected, I need the
subform to update to
the new records.
Regards
Pete
--- In
AccessDevelopers@yahoogroups.com,
"Liveson Tumbulu"
<[EMAIL PROTECTED]...>
wrote:
>
> Pete
>
> I think basically you have two
tables one for authors and the
other for books. Create one query which
should include AuthorID,
Books, etc. Then create a form bound to this
query. You may not need
a query after all. The form may simply be bound to
the Books table
with selected fields.
>
> Create an unbound
form and on it place a combo box named say
cmbAuthorID , then place the
first form on it. The combo box should
lookup the values from the Authors
Table and not the query. The
combo box may have fields like AuthorID,
Surname, FirstName, Penname
(from the Authors table) but the bound field
is AuthorID. Set the
Link Master and Link Child fields to AuthorID
(AuthorID is the
primary key in Authors table and a foreign key in the
Books table
and should be present in the subform). You may create another
text
box or label that displays Author's full names on the parent form
once the combo box gets updated. This should work for you.
>
> Northwind database sample has very good examples of subforms.
>
> HTH
>
> Liveson
>
> -----
Original Message -----
> From: Pete Harrison
> To: AccessDevelopers@yahoogroups.com
> Sent: Thursday, October 13, 2005 11:40
AM
> Subject: [AccessDevelopers] Forms and Subforms
>
>
> I cannot seem to do something that should be so
easy.
>
> I want a form with a subform
>
> The main form wants a dropdown list of author surnames
and their
pen
> names.
>
> The
subform needs to display a list of books they have written.
>
> I have a query that creates a list of all books sorted by
authorID
> for the subform and a quert that creates a
list of author
surnames,
> pen names (if they have
them) and authorID.
>
> What I end up with is a
dropdown which only show 1 author and
record
>
navigation to move to the next author.
>
> Where am I
going wrong?
>
> Regards
> Pete
>
>
>
>
>
>
>
> Please zip all files prior to uploading to Files section.
> Yahoo! Groups
Links
>
------------------------ Yahoo!
Groups Sponsor --------------------~-->
Fair play? Video games
influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go
to:
http://groups.yahoo.com/group/AccessDevelopers/
<*>
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*>
Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Please zip all files prior to uploading to Files section.
YAHOO! GROUPS LINKS
|
