Linking Command button to combo boxes to get a report

[bhalsonu]

I am facing a problem. i am very amateur at access. I want to design a form on which there is one combo box and one command button. If i made a selection from the combo box and clik on command button it should show all the details related to that particular selection (say Shop Order) on a report. I dont know how to link this things.

report may be like..
Shop Order Description Length Width Hight..
Ax12 xxxxxx xxx xxx xxx
Ax 12
for a particular shop order selection there may be no. of parts that should show on.
like an assembly thing. Suppose Shop order for a bag is A23 and its different parts are belt and chain...
now
SHOP Order description ......\
A23 belt
A23 Chain...

i hope i described my problem..
please do help if you can..
Thank you
Hemendra

 

[Ukraine82]

Try this.....

Dim strDocName As String
Dim strLinkCriteria As String

strDocName = "ReportName"
strLinkCriteria = "[FieldName] = Forms![FormName]![FieldName]"

DoCmd.OpenReport strDocName, acViewPreview, , strLinkCriteria

hth,
Michael

 

[bhalsonu]

thank you

thank you
it worked out well