 | |
populating a combobox with values from two tables
comp.databases.ms-access comp.databases.ms-access
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: populating a combobox with values from two tables -
07-06-2010
, 12:45 PM
|
g wrote: On 7/5/2010 12:40 AM, Salad wrote: g wrote: I created a form, added a combobox to it and want the combobox to be populated by values from two different tables. For the rowsource property of the combobox I am using below query (SELECT DISTINCT [Table1].Column1 FROM [Table1]) UNION (SELECT DISTINCT [Table2].Column1 FROM [Table2]) ORDER BY [Table1].Column; but it does not work. When I try to view the form in Form view, and try to choose an option from the combobox I get a message(which is like a textbox) "Enter Parameter Value Table2.Column1 and a place to enter some value and a OK, Cancel button. Why am I getting the message when I try to access the combobox and how can I fix it? I am using Access 2007. Any advice would be welcome. Have you even attempted to run the rowsource in the query builder? If it doesn't run as a query, why would you expect it to run in the form? It did not. That is why I posted to seek help to know what I was doing wrong. Then you need to improve your debugging skills. I would have created SELECT DISTINCT [Table1].Column1 FROM [Table1] as one query and tested it and SELECT DISTINCT [Table2].Column1 FROM [Table2] as another and tested prior to asking. |
Quote:
|
Maybe if you ask in 5 or 10 more Access newsgroups you'll get a definitive answer. As I told you before, I do it because some people read only one forum and others another so I guess if I post in both, I can get advice from both. FYI, people who are regular posters in this forum may not have time always to respond whereas someone else who may be a regular in another Access forum(where I may have posted) may respond sooner which can solve the issue. Lot of my posts in this forum were not responded at times(and many were responded too and you also helped me a lot for which I am grateful to you and all who responded). In this situation, John gave an answer which solved the issue. When someone is stuck up, he does not seek one source of help as for some reason if that source is busy/not available, he has to wait or may not get the help. Instead, he seeks different sources which can help him out. As long as I acknowledge(and thank) the posters time and effort in the groups I posted and tell them what solved the problem(which helps people who may read the thread in the future and benefit from it), I don't think I deserve to be blamed for cross posting. Who cares. There's a shitload of microsoft.public.access newsgroups. I'd recommend finding one of them that has a pulse and post there. |
#12
| |||
| |||
|
|
g<g_1@g.com> wrote in news:UxpYn.3428$Zp1.1266 (AT) newsfe15 (DOT) iad: On 7/5/2010 12:40 AM, Salad wrote: Maybe if you ask in 5 or 10 more Access newsgroups you'll get a definitive answer. As I told you before, I do it because some people read only one forum and others another so I guess if I post in both, I can get advice from both. Your assumptions are basically wrong. Since MS discontinued their news server/web-based interface to the Usenet groups, there is a very small handful of groups with posts. Even beyond that, all the Access gurus that I'm aware of were reading all the microsoft.public.access.* newgroups regularly, so you were much more likely to annoy by multi-posting than increase your chances of getting help. Really, at this point, so far as I'm concerned the only two newsgroups to post in are comp.databases.ms-access and microsoft.public.access. If you don't get an answer in those, you're not going to increase your chances by posting to one of the specialized newsgroups. |
microsoft.public.access)and one of the group was in CC so the person
reading from one group would likely see that it is being posted to
another group and ignore my message when he retrieves messages from the
other group) and in Utteraccess forum. FWIW, sometimes I have received
quicker and more help there(Utteraccess) than here. No disrespect to
this group at all. You, Salad, John, James are really great helpers
indeed, but sometimes my post does not get answered here and there it
does. The vice versa also happens. When a poster posts, he needs help so
that he can solve the issue and move forward. Posting at
comp.databases.ms-access and microsoft.public.access sometimes takes a
day for answers(which is perfectly understandable as you all are
volunteering and have other tasks to do), but if in UtterAccess I get a
response quicker which helps me to move forward, I don't understand why
should that annoy anyone?
Again, thanks to all the generous commitment of time all the regular
posters of the comp.databases.ms-access and
microsoft.public.access provide.
#13
| |||
| |||
|
|
I was posting in those two groups(comp.databases.ms-access and microsoft.public.access)and one of the group was in CC so the person reading from one group would likely see that it is being posted to another group and ignore my message when he retrieves messages from the other group) |
likely reading the other, and I, for one, find it annoying to see
the post in both places. Of course, I could change my news reading
methods in a way that would cause the second occurence to not show
up (by reading one group, catching up, then opening the second
group), but I'm not going to do that.
While crossposting is preferable to multi-posting, I would advise
against it, nonetheless.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.