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

Not sure how to ask this question about data on a form

P: 1
IN the form design, I have made a certificate with a number of combo boxes. My ultimate outcome of this is to click on the membership Id. number and then automatically the name, and date of birth appears on the certificate. I have spent days trying to figure this out, and I have no clue how to do it.
Aug 6 '07 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,669
IN the form design, I have made a certificate with a number of combo boxes. My ultimate outcome of this is to click on the membership Id. number and then automatically the name, and date of birth appears on the certificate. I have spent days trying to figure this out, and I have no clue how to do it.
You've given me very little to work on so I'm assuming you have a Combo Box of membership IDs and after 1 is selected, you automatically want to populate the Name and Data of Birth Fields. If this is so, here is a basic code template:
Expand|Select|Wrap|Line Numbers
  1. Private Sub cboMembershipIDs_AfterUpdate()
  2. If Not IsNull(Me![cboMembershipIDs]) Then
  3.   Me![txtName] = DLookup("[Name]", "tblYourTable", "[Membership ID]=" & Me![cboMembershipIDs])
  4.   Me![txtDateOfBirth] = DLookup("[Date of Birth]", "tblYourTable", "[Membership ID]=" & Me![cboMembershipIDs])
  5. End If
  6. End Sub
  7.  
Aug 6 '07 #2

Post your reply

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