If initiate = True Then
SQLStmt = "Select [Work Order ID] from [Inventory WorkOrder] where [Work Order ID]=" & ID
DoCmd.OpenForm "yworkOrder2", acNormal, , SQLStmt
I am trying to open yworkOrder2 form with specified ID number.Id number is held in ID global variable. it doent give me any error message in SQLSTmt ..but it gives me erro'3075' when i try to access that query in DOcmd.openform statment.
any help will be appreciated .thanx in advance.