find den rigtige post.?

Uc>Hard to give a solution as we cant see how things are put together, is it possible to send the dB to me at eksperten@santhell.dk so I can take a look?

You could also make a query and then use expression builder to build the criteria for the WHERE. Make sure that the form is open when you do this and Access will find the right objects (forms/fields/combo's) for you to choose from.

once the query is made then use this as the row source for the combo

Terry
DB is on the way..

UC.

OK, I have it!

No, I dont, that was from someone else :o)

Now I do :o)

OK, this is just a dirty work around, normally the row source for the combo will show the same values for all records in the detail.

First make a query which you use as the row source for the combo.

SELECT UnderArtikel.UnderArtikelBeskrivelse
FROM UnderArtikel
WHERE (((UnderArtikel.ArtikelNr)=[Forms]![view]![artikel]));

Then make an after update event for the artikel field. This is so that IF you enter a new artikel the combos values change.

Private Sub artikel_AfterUpdate()
    If Not IsNull(Me.artikel.Value) Then Me.UnderArtikelBeskrivelse.Requery
   
End Sub

Then make an event for the form so that each time you move to a new record the combo's values change.

Private Sub Form_Current()
    Me.UnderArtikelBeskrivelse.Requery

End Sub


NOTE: If you change the artikel for an extisting record then it is possible that underartikler is no longer valid! I'll let you work out how to take care of that :o)

mvh
Terry

HURRA FOR TERRY..
Damm you are goooooooooooooooood
Rock n' Roll  det spiller bare.

tak.
UC :-) God Weekend...

selv tak og god weekend :o)