åben specifik form uden filter

Use the forms recordsource

DoCmd.OpenForm "YourForm", , ,,,,me.SomeValue

In the On Open event of the form

If Not IsNull(me.openargs) Then
me.recordsource = "SELECT * FROM YourTable WHERE SomeField = " & Me.Openargs
else
me.recordsource = "SELECT * FROM YourTable"

end if

The LAST paramater of the Openform is the OpenArgs paramater which gets sent to your form. This can be used as the example shows.

I see
nice to have you back...

thanks juks!
What do you mean "nice to have you back"? I havent been anywhere!

I just dont have time during the day. Dont get paid for answering question on eksperten :o)

terry ? 
det var ikke den rigtige løsning . det giver det samme i sidste ende jeg ville gerne have en løsning hvor den går til en bestemt post men ikke filtere så jeg stadig kan "cykle" mellem posterne altså bruge pagdn elign.

det er ikke særligt bruger venligt at man lige pludselig ikke kan "cykle" rundt i gennem de forskellige records

denne her virker 


Dim rs As Object

    Set rs = Me.Recordset.Clone
    rs.FindFirst "Kunder.KundeID = " & Str(Nz(Me.OpenArgs, 0))
    If Not rs.EOF Then Me.Bookmark = rs.Bookmark

ja plus
me.comboUndercategori.requery

sorry glem lige
kommentar: juks
15/10-2003 23:03:35

roder to spg sammen tror jeg smutter i seng