Limiting data in a combo box

[Guest]

I have two tables that are joined: sponsors.sp_id and entities.nt_sp_id. The
data in the entity table contains both sponsored people and unsponsored
things. What I want to do is populate a combo box with data that is 1)
specific to that sponsor and 2) with things that do not have a sponsor. Can
you help?

 

[Van T. Dinh]

Try The Access Web article:

http://www.mvps.org/access/forms/frm0028.htm

 

[Guest]

I did read the article that you referred me to prior to me asking the
question. However, being less than novice in Access and your absolute
assumption that I know MVB all I can say is "WHAT?" Maybe the first place I
should start is asking a simple question in MVB rather than here. Is that a
good assumption Mr. Dinh? Thank you for your help.

Sorry for my being so stupid. Please help.

 

[Van T. Dinh]

What is MVB?

 

[Guest]

Is the "code" that is entered not in Microsoft's Visual Basic? That is what
comes up on my page. Am I wrong? I don't see where this is helping resolve
my desire for help at all. Maybe I should just give up on trying. I cannot
believe that I am so dumb.

Sorry again for the stupidity of mine that is eeking out. I just thought
that this forum was for those that don't know. I guess that I am wrong.

~a little frustrated~

 

[Van T. Dinh]

Sorry, I normall use VB for Visual Basic, not MVB. In Access, we actually
use VBA (Visual Basic for Application).

To do what you want, you need either VBA or Access Macros. Since Macros
have drawbacks and not as powerful as VBA, most of samples are done in VBA
and not Macros.

 

[Guest]

Well, guess it is going to be a long time before I can get this resolved. It
now appears that I need to go through all of the documentation in VBA to find
out what I need to do. I thought that this was going to be easy, but, (like
my experience with Microsoft) nothing comes easy. I have been very
proficient in C for near 30 years. Looks like it is starting over time now.

Thanks, Van, for pointing me to where I now need to go.

 

[Van T. Dinh]

If you know C well, it shouldn't be too hard to pick up VBA.

I think all you need is a good book on Access VBA programming. Read through
the first few chapters to know the features of the VBE (Visual Basic
development Environment), i.e. the coding window / interface and you find it
reasonably easy to do VBA coding.