Combo List on the form (Version 2)

[learning_codes]

(e-mail address removed)­m View profile
More options Sep 13, 3:31 pm

Newsgroups: microsoft.public.access.forms
From: "(e-mail address removed)" <[email protected]>
Date: Thu, 13 Sep 2007 12:31:46 -0700
Local: Thurs, Sep 13 2007 3:31 pm
Subject: Combo List Code link on the Main Form
Reply | Reply to author | Forward | Print | Individual message | Show
original | Remove | Report this message | Find messages by this
author
Hi,

I am trying to get a link on the form that has a field to link the
combo list. Each record has the different combo list.


Query - DATA has the field call GroupCD


Table for Combo List has two fields..... GroupCD and List


On the form, I want the GroupCD link to GroupCD (ComboList) so that
each record has the own combo based on the table (Combo List).


Your help would be much appreciated.


Thanks

I have read this over and over. I see this posted several times with no
responses.
I believe that everyone is still not understanding what you are asking.

Tell you what: Have someone sitting next to read what you wrote and have
them try to explain it back to you. You may have blinders on being so close
to the project.

Can you explain:
What do you mean by "link on a form"?
What do you mean by "each record has the own combo"?
What are you referring to when you say List and Combo List?

Try re-wording and re-posting please.
Make it as short and direct and as clear as possible.

We'd all really like to help, but you have to help us to help you.

Thanx.

Hi

Sorry for not explaining clearly.

There are two tables right now. I create a new form that line to
one of the two tables. The other table is for Combo List. Both
tables have the same field called GroupCD. On the form, it has all
the information on the form and also combo list. Combo List has 20
lines with different GroupCD. On the form, how do I make the groupcd
from two tables link together on the form. I want to see the form and
selected combo list that limited to 5 lines.

Your help would be much appreciated.

 

[Beetle]

Your question is not very clearly worded, so it is difficult to understand (a
fact which jmonty tried to explain in a response to one of your many previous
threads) but here is what I THINK you are trying to say;

1) You have a form that uses a query (named DATA) as it's record source.

2) On this form you have a combo box.

3) The query and the combo box both contain a field named "GroupCD"

4) "GroupCD" is the bound column of the combo box.

If all of the above is true, then do the following.

1) Open your query in design view. In the criteria row for the "GroupCD"
column put; Forms!NameOfYourForm![NameOfYourComboBox]

2) In the After_Update event of your combo box put; Me.Requery

If I misunderstood your question, or if you don't understand something about
the reply, then re-post whithin this same thread. You have already started at
least 4 threads on this same topic. Don't keep starting new threads over and
over because it will only make it LESS likely that someone will help you.

HTH