Hi! I'm new, both to this forum and Access 2007. I am making repairs and changes to an ages-old database (which has already been updated to version 2007).
Here's my situation:
I think this is exactly the solution I need. However...
The answerer provides this code:
I changed "res_num" to "Quote #"... the lookup field.
I get: "Compile error: Expected: end of statement"
Can anyone steer me in the right direction? From the list of quotes, I want to open a form showing only one quote.
Thanks!
Here's my situation:
I have a form which displays a list of records pertaining to a specific customer.
I want to click (double-click, whatever) -- either on a record, or on a button which appears on each record line.
This will open another form, showing more data specific to the clicked-on record.
On this forum, I found a post titled, "Click on list item and open a detail form" from 07-31-2007. (Can I paste a link to this post? http://www.access-programmers.co.uk/forums/showthread.php?t=132925&highlight=click+list)I want to click (double-click, whatever) -- either on a record, or on a button which appears on each record line.
This will open another form, showing more data specific to the clicked-on record.
I think this is exactly the solution I need. However...
The answerer provides this code:
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmEditRes"
stLinkCriteria = "res_num=" & Me.res_num
DoCmd.OpenForm stDocName, , , stLinkCriteria
I changed "frmEditRes" to "Quote Infor"... the name of the form I want to open.Dim stLinkCriteria As String
stDocName = "frmEditRes"
stLinkCriteria = "res_num=" & Me.res_num
DoCmd.OpenForm stDocName, , , stLinkCriteria
I changed "res_num" to "Quote #"... the lookup field.
I get: "Compile error: Expected: end of statement"
Can anyone steer me in the right direction? From the list of quotes, I want to open a form showing only one quote.
Thanks!