vba - retrieve the data of the whole row as label by giving one field value of the row a -

i'm using ms access 2010 , i'm facing problem in connecting text box , table data.

the scenario: i've created form contains textbox named txtpart control source textbox is:partnumber. field containing numbers in table dbo_v_stores.

i have created button print label. when button clicked should display label holds part number , few fields of table relate part number.

with system if store person wants print label, if types part number , clicks print button , label should generated details of product.

i tried connect button following code:

dim strreport string  dim strfield string  dim strwhere string  dim lngview long  strreport = "labels_stores_test"  strfield = "[dbo_v_stores.part]"  lngview = acviewpreview  if str(me.txtpart)  if strwhere <> vbnullstring  strwhere = strwhere & " , "  end if  end if  if currentproject.allreports(strreport).isloaded  docmd.close acreport, strreport  end if  

can suggest how can print label if user enters 1 field value i've tried doing failed desired output. appreciate if me out in issue.

if purpose of form user enter/select partnumber, , textbox should un-bound. instead of textbox, suggest combobox (cbopartnumber) rowsource of partnumbers make easier users. report should bound table , constructed needed. leaving out validation code simplicity, need open report partnumber criteria. docmd.openreport <yourreportname>, acpreview, , "partnumber=" & me!cbopartnumber if partnumber text field, change docmd.openreport <yourreportname>, acpreview, , "partnumber='" & me!cbopartnumber & "'"