Home » Developer & Programmer » Forms » Narrowing query using checkbox
Narrowing query using checkbox [message #472884] Tue, 24 August 2010 10:06 Go to next message
ahazin
Messages: 39
Registered: August 2010
Member
I stumbled across a small problem. I currently have a form that allows user to add records and query. One of the options when adding a record is that if a house has a conservatory the user would check the checkbox for the conservatory. However, when querying if the user wants to search only for houses with conservatorys they would check the tickbox to say that they only want to find houses with one. However this then displays a message stating FRM-41009: function key not allowed. Press ctrl K for list of values. when i click on the checbox to narrow the search down.

Is there any way round this?


P.S. Query is allowed on the checbox, the xheckbox is a database item, there is no code behind the checkboxes
Thanks.

Report message to a moderator

Re: Narrowing query using checkbox [message #472888 is a reply to message #472884] Tue, 24 August 2010 10:15 Go to previous message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Should work - have you got a WHEN-CHECKBOX-CHANGED trigger at block or form level?
If you change it to a text-item does it work?

Report message to a moderator

Previous Topic: Executing query when display box value changes
Next Topic: How to Debug a form
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 17:19:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.