Ask Experts Questions for FREE Help !
Ask
    slc193's Avatar
    slc193 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jun 4, 2009, 11:40 AM
    Go to specific record from report
    I am using Access 07. I have an invoice form and a I have created a query to find invoices of specific criteria. How do I make it so that I can click on a record in the query (or report based off the query) and it opens the invoice form and goes specifically to that record to review or edit it? TIA.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Jun 4, 2009, 12:13 PM

    Reports and queries are not interactive. You need to use a form instead. Create a form in continuous form mode bound to the query. You can then use the On Double Click event of invoice number control to open another form with that record by using the WHERE clause of the OpenForm method. Something like:

    Docmd.Openform "formname",, "[InvoiceID] = " & Me.InvoiceID
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Matlab 'goto' statements [ 3 Answers ]

Okay, so I have previous knowledge of Visual basic and Q-basic and well in these programs if I wanted to go to a certain line I would write 'goto 1' or 'goto line 1' etc. Does anyone know the notation for such a move in Matlab (if this is a legal move in Matlab)?

Removing a Judgment from Credit Report & Public Record [ 5 Answers ]

Hi, I am in the midst of trying to clean up my credit report, get inaccurate things off and update current derrogatory info. I intend to disput everything I possibly can. However what concerns me most is a judgment on my report and its public record (placed in 2004). Is there anyway that I...

Record Specific [ 2 Answers ]

Can you tell me my record here ?:)

View more questions Search