Recent content by robhoek

Doesn't work means that Access still asks me for a value for Opkomstid and if I fill in a valid number, it shows all the records instead of the one I want. The type of Opkomstid is Autonumber and yes, qryOpkomst is realy the name of a report. It is automatically made from a query that is also...

Thanks for the reply, But it still doesn't work. This is the code I've made in VBA: Private Sub Command37_Click() DoCmd.OpenReport "qryOpkomst", acViewPreview, , "Opkomstid = " & Me.Opkomstid End Sub I can't figure out what's wrong with it. Can anyone help me? Rob

Hey, I have a problem. I'm using Access 2010 and I'm trying to print a report of one specific record. It should be the record I'm viewing in the form. I've tried all the things posted here, but it does not work. Access either asks me to fill in the ID myself or it just says the where condition...