A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

SubForm, or something Else?



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old June 5th, 2010, 07:08 PM posted to microsoft.public.access.forms
JMay
external usenet poster
 
Posts: 300
Default SubForm, or something Else?

I have Chosen (big Grin) to utilize the new Multivalued fields option offered
in Access 2007. But, as always, I get started very excited, but am unable to
finish...

Not sure how to design my Form - but it would be a Main Form Sub Form
With ChurchID (as Main) and a Subform with
PositionTitle1 (Non-repeating)
(Indented) MinisterName1
(Indented) MinisterName2
(Indented) MinisterName3
PositionTitle2 (Non-repeating)
(Indented) MinisterName1
(Indented) MinisterName2
(Indented) MinisterName3

I'm totally confused as to how to proceed... Can anyone assist?

Here is my Query (easy and straight forward)

qryTieChurchNeedsToMinister

ChurchID, PosTitle, tblMinisterAssignment.MinisterLastNameFirstName.Va lue
25, Music, Kirk Arthur
25, Music, James Braswell
25, Music, John Duke
25, Music, Brian Lee
25, Music, Tommy Valentine
25, Children, Matt Addington
25, Children, Chris Aho
25, Children, Joe Aldrich
25, Children, Michael Aldridge
25, Children, Allen Allen
25, Children, John Allen
25, Children, Anna Anderson
25, Children, Mary Carol Anderson
25, Children, Joshua Apple
25, Children, Kirk Arthur



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:45 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.