combo boxex/listboxex

D

dennis

i have a combo box on my form which allows me to select data and add to my
list box and works well. now i want to add data from a different table to the
same list box? help please
 
S

Steve

Your combobox gets data from a value list, table or query. That's part 1.
Create a query based on your table so you can set criteria so you can select
the data you want from the table. That's part 2. Create another query that
gets data from part 1 and also includes the query in part 2. Use this query
as the rowsource of your listbox.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
D

dennis

thanks steve ,i said i was learning! what criteria should i set in my new
query based on the table iam using.
 
J

John W. Vinson

THANKS STEVE I SAID I WAS LEARNING! WHAT CRITERIA DO I USE IN THE QUERIES
Click to expand...

Don't shout, please, Dennis. You posted this at 8:24pm and again at 9:55.
Steve, like the rest of us, is an unpaid volunteer donating time on the
newsgroups. He very well might have shut down his computer for the day.
Reposting a querulous demand 90 minutes later shows a lot of impatience.

I haven't followed this thread but if you haven't posted a description of your
tables, neither Steve nor anyone else can tell what criteria to use in your
queries. You can see your database... we cannot.

John W. Vinson [MVP]
 
D

dennis

my apologies john your slap on the wrist was warranted i will talk quieter in
future.
i will start again
i have two tables one contains data on 118 club members,on my form i have a
combo box unbound from which i select members to play on a certain day.this
information is saved to a seperate table via a list box which is also
unbound.this works well i now want to add from a the second table visitors to
the club who wish to play on the same day.i also want to add them to the same
list box.if this requires creating queries,perhaps you could help me with
setting up the criteria?.many thanks rgds dennis
 
J

John W. Vinson

my apologies john your slap on the wrist was warranted i will talk quieter in
future.
i will start again
i have two tables one contains data on 118 club members,on my form i have a
combo box unbound from which i select members to play on a certain day.this
information is saved to a seperate table via a list box which is also
unbound.this works well i now want to add from a the second table visitors to
the club who wish to play on the same day.i also want to add them to the same
list box.if this requires creating queries,perhaps you could help me with
setting up the criteria?.many thanks rgds dennis
Click to expand...

A Listbox isn't ideal for this purpose: a subform would be better. I don't see
what benefit you get from using a Combo Box to add data to a Listbox, when you
then must have code to move that data from the Listbox to a table! Why not
instead simply have a continuous Subform with a combo box, so that you can
just pick one record after another?

If you do have to use a listbox, it's possible - but it certainly makes it
harder for you as the developer, and I can't see that it makes it easier for
the user.

John W. Vinson [MVP]
 
Top