databundet subform ønskes nulstillet (Tom)

Set them both to empty

.LinkMasterFields = ""     
.LinkChildFields = ""

Giver det modsatte resultat
Alle record listes ud

You obviously have a reason for wanting to do this. If you don't want to show anything on sub form then why use link fields or set record source?

Det behøver ikke være LinkMaster/ChildFields

Jeg kan lave det med:

SQL hvor Id er sat til 0
.RowSource = SQL

Men det er for omstændigt da det skal anvendes 40 x 5-6 steder

Findes der en anden enkel måde?

Men det er for omstændigt da det skal anvendes 40 x 5-6 steder


well I guess that must apply to the link fields also!

no matter what method you use, if you have ( 40 x 5-6 steder)
then you will need to alter all places.

You can change rowsource, or use forms filter property, but again, you will STILL need to do it (40 x 5-6 steder)


Why do you think it easier using link fields?

?

Der var desværre ingen anden mulighed end:
Med postkildens SQL hvor Id er sat til 0 bliver det nulstillet (tom) som jeg ønsker det

Terry du skal have point

:-)

Undskyld -prøv igen

Don't worry about the points :-)