Search results
-
E
Like criteria and combo box
It's not working: I'm still confused!! I want to replace the parameter box with my own combo box, so to do this I make a form with an unbound combo box on it. In the query Criteria row, I type [Forms]![thenameoftheform]![nameofcombobox]. I leave the form open and run the query. The query should... -
E
Like criteria and combo box
Ive created the Unbound combo box and form (as in: [Forms]![c_RenewalDate]![RenewalEdition] ), but how do I get the query to recognise the form combo box as the replacement for the parameter box? that's the bit I didn't understand. (I've tried editing the LookUp field properties in the query... -
E
Like criteria and combo box
yeah, that bit I know: I can return the data I want, but if one of my users spells the parameter data wrong, then they wont understand why the query returns no data. Therefore, the problem I have is that I want the combo box to appear (so as there is no chance that they can spell it wrong) not... -
E
Like criteria and combo box
Trying (as previous thread) to get a combo box to appear when running a query, instead of a message box, to display returned data 'Like' data held in a table. I did as Maxmangion suggested: [Forms]![c_RenewalDate]![RenewalEdition] is in my criteria row, referencing an unbound combo box in... -
E
Like crieria and combo box
thankyouthankyouthankyouthankyou thankyouthankyouthankyouthankyou! very much appreciated! -
E
Like crieria and combo box
Like criteria and combo box When you put Like [Enter Criteria] into a query criteria row you get a message box which call up data from a certain table column. How can I get that message box to become a combo or list box displaying a list of all the data available in the column, rather than the... -
E
control tip delay
I'd appreciate it if anyone could tell me how to edit the control tip delay in form design: ie: so as the controltip comes up much sooner than the default set by access? many thanks