B
BD
I am in the process of developing new front end program for SQL
database to replace MS Access front end. I have been unable to
convert the following lines of VBA to C# to find a record in the
workorder dataset from a seperate form based on query presented in
datagridview. I open the workorder form, then click on search form,
then double click the line in datagridview to focus back on workorder
to the selected record by workorderID.
If IsNull(Forms![Search SO Open]![List0]) Then
MsgBox ("You did not select a record to search for")
Else
DoCmd.SelectObject acForm, "Work Orders"
DoCmd.GoToControl "WorkOrderID"
DoCmd.FindRecord [Forms]![Search SO Open]![List0], acEntire,
False, acDown, False, acCurrent
DoCmd.SelectObject acForm, "Work Orders"
DoCmd.GoToControl "WorkOrderID"
DoCmd.Close acForm, "Search SO Open"
End If
Any help or guidance is greatly appreciated and thank you in advance.
BD
database to replace MS Access front end. I have been unable to
convert the following lines of VBA to C# to find a record in the
workorder dataset from a seperate form based on query presented in
datagridview. I open the workorder form, then click on search form,
then double click the line in datagridview to focus back on workorder
to the selected record by workorderID.
If IsNull(Forms![Search SO Open]![List0]) Then
MsgBox ("You did not select a record to search for")
Else
DoCmd.SelectObject acForm, "Work Orders"
DoCmd.GoToControl "WorkOrderID"
DoCmd.FindRecord [Forms]![Search SO Open]![List0], acEntire,
False, acDown, False, acCurrent
DoCmd.SelectObject acForm, "Work Orders"
DoCmd.GoToControl "WorkOrderID"
DoCmd.Close acForm, "Search SO Open"
End If
Any help or guidance is greatly appreciated and thank you in advance.
BD