Double Click Query field to jump to specific form record 1

[houstonbill]

I have a question which may seem a bit dumb but again I am trying something I have not done before. Have a form with a button that opens a query with several jundred records in data sheet view. Each has a OrderID # assigned to it. I want to be able to double click on a specific order number on the query and jump to the specific form record. If I was working from a form to a form, no problem. But from a query to a form, I am not quite sure. I would think I need to do something like the below, which if working from a form/buttons, I would set an event (on double click) but I don't have that option on my query.

Dim strWere as String
strWhere = “[OrderID] =” & Me.[OrderID]
DoCmd.OpenForm “frmWrkOrder”, acFormDS, , strWhere




Dim strWere as String
strWhere = “[OrderID] =” & Me.[OrderID]
DoCmd.OpenForm “frmWrkOrder”, acFormDS, , strWhere

 

[dhookom]

You don't have any "live" click or on current or similar in a query or table datasheet view. You can possible create a datasheet view of a form.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[houstonbill]

I have been working with it and kind of having it work. I do have a question though. I put a button on the Work Order form, which in turn opens the "frmPal" which has it properties set to Datasheet view. Problem is, that when it opens, the appearance is a regular form rather than the datasheet properties. If I open the "frmPal" by itself, it is datasheet view. From the button, it is a form. Why is that?

 

[dhookom]

Your code in the On Click of the button on the Work Order form doesn't specify to open datasheet.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[houstonbill]

OK. Here is where I am at. The button opens the form in form view rather than datasheet. when I double click on the order ID # I want, the record form opens in Datasheet view rather than form view. Both actions are opposite of what I want. I have looked at lots of samples and tried differnt options, but none are working. In my on click event for the command button that will open the form, how would I format it? I assumed it would look like acOpenDataview but I am unalbe to get the positon correct. Your assistance would be appreciated, although I will continue searching for the right way to make it work.

Private Sub Command208_Click()
On Error GoTo Err_Command208_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmWorkingPal"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command208_Click:
Exit Sub

Err_Command208_Click:
MsgBox Err.Description
Resume Exit_Command208_Click

End Sub

 

[dhookom]

You had the code in your first posting in this thread...

Private Sub Command208_Click()
On Error GoTo Err_Command208_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "frmWorkingPal"
    DoCmd.OpenForm stDocName, acFormDS , , stLinkCriteria

Exit_Command208_Click:
    Exit Sub

Err_Command208_Click:
    MsgBox Err.Description
    Resume Exit_Command208_Click
    
End Sub

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[houstonbill]

Oh..........so close. I was off by 1-comma, and instead of DS I was spelling it out. I was also able to write the code for the double click on the field to then open the subsequent Work Order form instead of datasheet.

Simple as this may seem, I am used to taking the easy way out by using the wizard for my buttons etc, and with that you do not necessarily learn how to change the code to do differnt things. So, again I have learned.

Thanks.