VBA Code Help for Report

[Mike4172]

I have a query set up with all information I Need but need to filter it for a report.

What I want to do is grab the current drivers liscense number being shown in access and pull all the records under that number.



Something to effect of "If DLnumber = match, pull each record in query where dl matches". One drivers liscense number could have several records in query. Any help I'd appreciate it.

[help_me_with_access]

Mike,

either base the rpt on a query that takes a paramater....or filter the report and refresh it with:

1)
me.filter = "[field] = '" & inputVal & "'" (for strings)
me.filter = "[field] = " & inputVal (for numerics)

2)
me.filteron = true

3)me.refresh

refresh, requery, or you may not even need to do either of those. I just remember those methods annoying me everytime I had to deal with them.

[Mike4172]

Hmmm looking thru others examples would something like this work?

DoCmd.OpenReport "rptDLs", acViewPreview, , "DL_ID = " & DL_ID

[help_me_with_access]

yes, that would probably work too.