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

how to use "multiple-items" form in continious view, click a row to open edit indivdu

P: 2
Hi,

I have an access database, i used multiple-item continious view form. I need the ability to click a particular record in this view to open a individual record edit form window.
Feb 7 '14 #1

✓ answered by mcupito

Expand|Select|Wrap|Line Numbers
  1.     Dim stDocName As String
  2.     Dim stLinkCriteria As String
  3.  
  4.     stDocName = "YourFormToEdit"
  5.  
  6.     stLinkCriteria = "[TheFieldYouWantToLinkTo]=" & Me![FieldYouWantToLinkFrom]
  7.     DoCmd.OpenForm stDocName, , , stLinkCriteria
On the [Event Procedure] OnClick of a button, here is some sample code. Hope this helps.

Share this Question
Share on Google+
4 Replies


Expert 100+
P: 1,221
Make a new form that edits one record. Then in your original, continuous view form, add a button to click, or use the click event on some object already on the detail line. In the click even of the button or other object, use docmd.openform to open the edit form you made. Use the where criterion on the openform command to tell the form which record it will be editing.

Jim
Feb 7 '14 #2

100+
P: 294
Expand|Select|Wrap|Line Numbers
  1.     Dim stDocName As String
  2.     Dim stLinkCriteria As String
  3.  
  4.     stDocName = "YourFormToEdit"
  5.  
  6.     stLinkCriteria = "[TheFieldYouWantToLinkTo]=" & Me![FieldYouWantToLinkFrom]
  7.     DoCmd.OpenForm stDocName, , , stLinkCriteria
On the [Event Procedure] OnClick of a button, here is some sample code. Hope this helps.
Feb 7 '14 #3

P: 2
@mcupito yes, this perfectly helped me! Thanks :)
Feb 7 '14 #4

100+
P: 294
Great! Glad I could help.
Feb 7 '14 #5

Post your reply

Sign in to post your reply or Sign up for a free account.