[AccessDevelopers] Re: Forms and Subforms

2005-10-13 Thread Pete Harrison
ison > To: AccessDevelopers@yahoogroups.com > 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 >

[AccessDevelopers] Re: Forms and Subforms

2005-10-13 Thread Pete Harrison
ionships? Until this information is available it may be difficult to figure out how a solution may be achieved. > > Good luck > > Liveson > - Original Message - > From: Pete Harrison > To: AccessDevelopers@yahoogroups.com > Sent: Thursday, October

[AccessDevelopers] Re: Forms and Subforms

2005-10-13 Thread Pete Harrison
ison > To: AccessDevelopers@yahoogroups.com > 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 >

Re: [AccessDevelopers] Re: Forms and Subforms

2005-10-13 Thread Liveson Tumbulu
difficult to figure out how a solution may be achieved.   Good luck   Liveson - Original Message - From: Pete Harrison To: AccessDevelopers@yahoogroups.com Sent: Thursday, October 13, 2005 12:56 PM Subject: [AccessDevelopers] Re: Forms and Subforms Liveson,Thanks for

[AccessDevelopers] Re: Forms and Subforms

2005-10-13 Thread Pete Harrison
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 pr

[AccessDevelopers] Re: Forms and Subforms

2005-10-13 Thread Pete Harrison
AccessDevelopers@yahoogroups.com > [mailto:[EMAIL PROTECTED] Behalf Of Pete Harrison > Sent: 13 October 2005 11:17 > To: AccessDevelopers@yahoogroups.com > Subject: [AccessDevelopers] Re: Forms and Subforms > > > OK, I've now got the dropdown lists populated by putting a

RE: [AccessDevelopers] Re: Forms and Subforms

2005-10-13 Thread Cathy Jupp
first thing I'd check. Hope this makes some sort of sense! Cheers Cathy -Original Message- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of Pete Harrison Sent: 13 October 2005 11:17 To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Re: Forms an

[AccessDevelopers] Re: Forms and Subforms

2005-10-13 Thread Pete Harrison
OK, I've now got the dropdown lists populated by putting a row sourse as a query against the source query for the form, but when I select a different author name, the subform does not change. Do I need some kind of afterupdate code? Regards Pete --- In AccessDevelopers@yahoogroups.com, "Pete H