I have try and try and try But no.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I try to explain.
I have a form there are based on a table with 2 Colums
the have only ciffers.

In the form i have 2 dropdownbox/combi the one of them look up
in a table and the record i click on send the Id to the form, thats ok
but the second dropdownbox, here i want not all records to come, if the
record all ready is on the other table then i don't want it to come in my
dropdownbox

The first Dropdown send maybe a ciffer NO:1
then i want the second dropdown to lookup in the table and see
what records there allready are there with first ciffers AS NO:1
And then i want these records not to come up in my dropdownbox

I hope someone understand my very bad english.

best regards
Alvin
 
Alvin Hansen said:
Hi
I try to explain.
I have a form there are based on a table with 2 Colums
the have only ciffers.

In the form i have 2 dropdownbox/combi the one of them look up
in a table and the record i click on send the Id to the form, thats ok
but the second dropdownbox, here i want not all records to come, if the
record all ready is on the other table then i don't want it to come in my
dropdownbox

The first Dropdown send maybe a ciffer NO:1
then i want the second dropdown to lookup in the table and see
what records there allready are there with first ciffers AS NO:1
And then i want these records not to come up in my dropdownbox

I hope someone understand my very bad english.

best regards
Alvin
Click to expand...

Hi Alvin,

I'll have a go! Let's suppose that your form is call frmMyform, the first
combo box is called cboCombo1, and the second combo box is called cboCombo2.

Now, you set the Recordsource for cboCombo2 as follows:

SELECT some fields from somewhere WHERE ciffer <>
[Forms]![frmMyForm]![cboCombo1]

Next, you put the following code in the AfterUpdate event for cboCombo1, and
also in the Current event for the form:

cboCombo2.Requery

I hope I've understood you correctly, and that this helps.
 
Back
Top