Mark A Matte
markamatte at hotmail.com
Wed Mar 2 14:59:09 CST 2005
Gershon, On the 'data' tab of the text box properties...there is a LOCKED property ( does not allow user to edit data in this field). This allows me to display the questions and a check box for each record...and the user can use the check box...but not edit the question. You can even go a step farther and use the textbox's format properties(back style,back color, etc.) to make it look like a label. Let me know if you have any other questions. Thanks, Mark >From: handyman at actcom.co.il >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >Subject: RE: [AccessD] tabbed form question >Date: Wed, 02 Mar 2005 20:19:00 +0200 > >Mark, > >what do you mean by 'locked' text boxes? > >Thanks > >Gershon > >At 04:17 PM, 03/02/2005 +0000, you wrote: >>Gershon, >> >>I do something similar...five tabs...different categories of questions on >>each tab. Instead of labels...I use 'locked' text boxes in a subform on >>each tab. The subform is driven by a table that contains ALL of the >>questions and is filtered by the question type for each tab. >> >>Hope that helps. >> >>Mark A. Matte >> >>>From: handyman at actcom.co.il >>>Reply-To: Access Developers discussion and problem >>>solving<accessd at databaseadvisors.com> >>>To: accessd at databaseadvisors.com >>>Subject: [AccessD] tabbed form question >>>Date: Wed, 02 Mar 2005 06:51:18 +0200 >>> >>>Hi all, >>> >>>I have a tabbed form which has a whole load of categories of different >>>parts that need to be purchased. Each category can have 1-30 items below >>>it. I want each tab under the category to list it's item names and a >>>checkbox. The user can then check off any items that needs to be >>>purchased. >>> >>>I thought of making a tabbed form that has all the categories, and then >>>have a subform that has 30 checkboxes and thru code fill in the checkbox >>>label with the item names - and make any unused checkboxes not visible. >>>Can anyone suggest an easier way? >>> >>>Thanks >>> >>>Gershon, (who still can't get my listbox wizards to work, but I ordered a >>>new version of office) >>> >>>Gershon Markowitz >>>mailto:Handyman at actcom.co.il >>>http://www.yadchaimtzvi.org >>> >>>-- >>>AccessD mailing list >>>AccessD at databaseadvisors.com >>>http://databaseadvisors.com/mailman/listinfo/accessd >>>Website: http://www.databaseadvisors.com >> >> >>-- >>AccessD mailing list >>AccessD at databaseadvisors.com >>http://databaseadvisors.com/mailman/listinfo/accessd >>Website: http://www.databaseadvisors.com > >Gershon Markowitz >mailto:Handyman at actcom.co.il >http://www.yadchaimtzvi.org >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com