syntax: DLookup(Express ion, Domain , Criteria)
Code:
=dlookup("[ColumnYouWant]","[YourTable]","[KeyColumn] = [Combo12]")
ClearRift
Last Activity: Feb 2 '11, 06:26 AM
Joined: Feb 1 '10
Location: Washington, DC
-
The combobox uses the key column to look up the correct values to place in the box. Therefore, you need to do the same thing. This is most easily done using the dlookup function like so:
syntax: DLookup(Express ion, Domain , Criteria)
Let me know if this helps. -
I could go into detail about this but it is best if you check out the article written by Allen Browne. This should help you accomplish the task.
P.S.- He's a member here!:)Leave a comment:
-
That did it!!! Wow, thank you. Now everyone will stop submitting problem tickets when it freezes on them.
Thank you so much!...Leave a comment:
-
ClearRift replied to how to dynamically change the tab that is showing based on criteria in the formin AccessI had the same problem when trying to change the tab based on a result from the form. When i used .value it didn't work. So i tried the following with success:
...Code:Private Sub Form_Current() Select Case Me.Division Case "Best Cheerleader" Me.TabCtl12 = 0 Case "Best Dancer" Me.TabCtl12 = 1 Case "Best Jumps" Me.TabCtl12 = 2 Case "Best Tumbling
Leave a comment:
-
Access freezes after sendobject command when user cancels e-mail
I've created an Access application in the 2003 file format that includes a button for the user to send a report via e-mail. The computers at work use Office 2007 products on Windows XP Pro with SP-3 but because of errors with our CRM we still use Outlook 2003.
Problem:
As long as the user actually sends the e-mail after the message opens in Outlook everything is fine. However, if the user closes the message without sending...
No activity results to display
Leave a comment: