[Forms]![FormName]![COMBO1184].Value
OR
[Forms]![FormName]![COMBO1184]
awake2424 said:I have a text box (Name) on a form in which the user selects a name, then I have a combobox set to Name.Column(1)...
Is there a limit in Access 2003 to the number of IIF statements that can be entered in a Field: of a query? Thanks.
Yes, the part YourFormNameHere is what needs to be changed to your actual form name. And txtName needs to be changed to the name of the text box which is on your form, if it isn't named txtName.When I use the code:
[Forms]![YourFormNameHere]![txtName]
it asks for a parameter to be entered. Is there anyway to avoid this?
You cannot address the .Column(1) Property of the Combobox in a Query column or in criteria. But, you can reference the default bound column like:
Code:[Forms]![FormName]![COMBO1184].Value OR [Forms]![FormName]![COMBO1184]