I am very new to access and trying to create a simple database.The form has an input text called documentnumber in which the user inputs data of the form xxx-xxx-aa where "x" can be any alphebet and "a" can be any number(eg"ext-frm-33") .After entering this input the user will hit the run button which will exceute a query to show the output.Using buttonwizard I connected my query to the commandbutton and the syntax I used for queryis "=[form]![myform]![documentnumber]" .However I am not getting anyoutput.Basically there is one table and one form in my DB and table has fileds namely documentnumber,issuedate and revisedate.when user inputs documnet number and run the query the output should display the issuedate,revisedate for the corresponding document number input.Can someone pls. help me with fixing this query?Is there anything wrong with my syntax?Is there any other way of doing this?Please help.Thanks.
Need help with syntax
- Thread starter newaccess
- Start date