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
|
|||
|
|||
Table Details not in Build
I would like to use the value of a combo box on a form as criteria, and it
isn't working. I tried to build the criteria and the details of the form don't show up. I tried saving the form, restarting access and nothing seems to be working. When I leave the criteria out I get all the records. Any Help would be greatly appreciated. Thanks in advance Ken |
#2
|
|||
|
|||
Table Details not in Build
The query criteria should look something like:
[Forms]![FormName]![ComboBoxName].[value] Sometimes you need the value on the end. Also the from must remain open. You can hide the form with something like this on the On Click event of a button on the from if you are using one to fire off the query: Me.Visible = False Lastly the value of the combo box is taken from the left most column of what is displayed. If you really don't want to see that value in the combo box, you can change the first column width to 0. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Ken" wrote: I would like to use the value of a combo box on a form as criteria, and it isn't working. I tried to build the criteria and the details of the form don't show up. I tried saving the form, restarting access and nothing seems to be working. When I leave the criteria out I get all the records. Any Help would be greatly appreciated. Thanks in advance Ken |
Thread Tools | |
Display Modes | |
|
|