Could somebody please help me.
I have an Access table with the following fields ID(Primary Key), Island, PlantNumber, RegNumber, Plant Description, AccNumber, AccDescription Tracked. I have created a connection to the table using ADO (Data Environment – deWorks, Connection – cnWorks, Command – cmWorks).
On the form I have a command button, a text box and the data grid control. When I enter the PlantNumber or RegNumber into the text box and press the command button I would like the records that meet the text box criteria to be displayed in the data grid.
Could somebody please give me an idea as the correct syntax that I could use for this
I have an Access table with the following fields ID(Primary Key), Island, PlantNumber, RegNumber, Plant Description, AccNumber, AccDescription Tracked. I have created a connection to the table using ADO (Data Environment – deWorks, Connection – cnWorks, Command – cmWorks).
On the form I have a command button, a text box and the data grid control. When I enter the PlantNumber or RegNumber into the text box and press the command button I would like the records that meet the text box criteria to be displayed in the data grid.
Could somebody please give me an idea as the correct syntax that I could use for this