If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Datasheet form based on a value in a combo box
I want to create a form in a datasheet view. Data displayed should be based
on a value picked from the combo box. For ex. a user will select his name in the combo box. Based on his name, his clients will be displayed in the datasheet view. How do create such a form? |
#2
|
|||
|
|||
use the value of the combo box to filter the records in the form's
underlying table, as Me.Filter = "MyField = " & Me!MyComboBox Me.FilterOn = True the above syntax is for Number data type.if the data type of MyField is Text, then change the syntax to Me.Filter = "MyField = '" & Me!MyComboBox & "'" hth "monia13" wrote in message ... I want to create a form in a datasheet view. Data displayed should be based on a value picked from the combo box. For ex. a user will select his name in the combo box. Based on his name, his clients will be displayed in the datasheet view. How do create such a form? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Displaying Additional Columns in Access Form | Roxanne | General Discussion | 3 | September 20th, 2005 06:50 PM |
Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |
Strange stLinkCriteria behaviour on command button | Anthony Dowd | Using Forms | 3 | August 21st, 2004 03:01 AM |
Design questions | Bruce | Database Design | 15 | June 19th, 2004 12:12 AM |