Datasheet or Subform?

[pedroghuk]

First visit to Access forum on this site!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I use Access XP version.<o></o>
<o></o>
I have created a FormA whose record source table is TableA.<o></o>
<o></o>
Within the FormA I have a field labelled 'Person' whose record source is 'Name' in TableA.<o></o>
<o></o>
'Name' has a text data type. Within the Field Properties of 'Name', in the Lookup tab I have:<o></o>
<o></o>
Display Control: Combo Box<o></o>
Row Source Type: Table/Query<o></o>
Row Source: tblName<o></o>
Bound Column and Column Count = 1.<o></o>
<o></o>
{In other words I have created a small lookup table (tblName) of names, linked to the 'Name' field in TableA}.<o></o>
<o></o>
My query is how do I get the end Users to select and display on FormA more than one Person?<o></o>
<o></o>
Each event can be associated to two or more Persons. I want the end User to select Person 1 then Person 2 and so on and the selected Persons to be displayed in a datasheet view on FormA or do I want to show the chosen persons in a Subform.<o></o>
<o></o>
I have seen this done but cannot work out how it was achieved.<o></o>
<o></o>
Any assistance will be gratefully received!<o></o>
<o></o>
Regards.<o></o>
<o></o>
<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1lace w:st="on"><st1:City w:st="on">Gary</st1:City></st1lace><o></o>
<o> </o>

 

[modterry]

Sir: Are you trying to run a query that aks: give all the names like smith?

If so your query should have a like clause in the code:

"%smi%"

I can do this in sql

SELECT
userid
lastname

from sometable

Where sometable.lastname is Like %name%

order by lastname

end query

 

[pedroghuk]

Thanks for your reply.

But no. I simply want the User to select a Person from a list and the person's name to be displayed on the form. I then want them to select another Person and this name to also be displayed on the form. I don't want to include separate fields for Person 1, Person 2 , Person 3 etc.
I would like to see all Persons selected in a datasheet or subform within FormA.
Hope this make sense.

Gary

 

[pedroghuk]

Ignore this thread.
I have managed to display my data on the Form as required.
Thanks.
Gary