combo/relationship problem

[robhargreaves]

I have a combo on a form that will allow me to choose a
site from the dropdown. This is based on a table and will
create a record when picked of a number relating to the
primary key in the combos source table.

I have another combo which I need to only show values
related to the first combo, almost like saying that
whatever is chosen in the first combo will limit the
second to entries corresponding to the choice. Mine
shows all of the entries not a limited selection.

I have tried a query but it doesnt work or I am doing it
wrong.

If you are willing and you think I havent explained enough for you to understand then I will attach or post a copy for you to look at

regards
R.Hargreaves

 

[krunalprajapati]

u have done right thing, may be ur query is wrong.

In the second combo ur where condition is like:

WHERE FILEDNAME = " & FORMS![FORMNAME]![UR FIRST COMBO NAME]

if the first combo has the datatype is text than add single quote " ' " before and after FORMS![FORMNAME]![UR FIRST COMBO NAME]
i.e. WHERE FILEDNAME = '" & FORMS![FORMNAME]![UR FIRST COMBO NAME] & "'"

than in the Lostfoucs event of ur first combo write code
Me![ Ur Second combo name].requery

hope this will help u.