By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,584 Members | 3,458 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,584 IT Pros & Developers. It's quick & easy.

Find Record From Search Form

P: n/a
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")
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.

Jun 13 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.