Hiding single items on a continuous form

E

efandango

I want to hide an address control with a tick box on only some records, but
not all; based on a continuous form. Can this be done?.

The User would select the tick box on the form(s) and would hide/unhide the
control depending on choice.

I want the hidden field to be part of a quiz, where the user
See’s the first part of the question; in this case Venue Name, but has to
guess the matching address, then clicks a button to see if he was correct. I
hope this makes sense, and that there is some kind of solution. Ideally I
want just one control for all 16 addresses on a continuous form, but I
understand on this type of form it is all or nothing, perhaps there is
another way?...
 
E

efandango

but would that mean a single form or single control, which means the user
would be restricted to one question/answer, instead of the 16 that i require
(on a single form)?
 
E

efandango

Alan,

Can you help me out wit this one please. Why would a subform enable me to
hide some addresses, but not a main form. Or can yo explain the general
outline principle or processes involved?
 
A

Arvin Meyer [MVP]

A subform is a control, not a form. It has form properties when it has the
focus, or, in code, we can refer to those properties. Each record of a
subform is an instance of the form. If you have an unbound control, or a
control which has a property, the subform shows that value (unbound control)
or that property for all controls.

For an example, put an unbound text box on a single view form that's bound
to a table. Now scroll through the records and you'll see that the textbox
you just made is empty in every record. Put the letter "a" in the textbox.
Scroll again and it's in every record. Now turn that single view form into a
datasheet or continuous form. Try the above experiment and the results will
be the same.

If you hide a control, it will be hidden for every record.

Now if you have a table of questions, you can create a combobox on a form to
choose a question from that table, Have a textbox next to the combo to hold
the answer, and another textbox (which can be hidden) to hold the ID of the
user and link to a main form.

If you want to make sure all questions are answered, add the full set of
them to a detail table for that user, lock the combos so they can't be
changed and each user will see all 16 questions and have a place to answer
them.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
E

efandango

Thanks for your help on this Arvin, though i suspect your solution doesn't
quite match my problem. I want to use tick boxes instead of combos for
example.

This 'Quiz' is a live database of 1 Delivery 'run' with 16 'point' delivery
addresses. In total their are 80 'runs'

I want the user to be able to scroll through each master record (Run) and
see the 16 'points' on a subform. then attempt to guess the 'points' relating
to each run. Their results don't have to be recorded, as the forms main
purpose is to show all 16 points; the hide-unhide address function is merely
as an ad-memoir device; but it must allow display and obscure functionality
on all 16 points at a time; which means your proposal for combos would not be
ideal. I hope my explanation makes sense. I have a version of this working in
my 1st attempt MDB, but it means i have to allocate 16 (point) fields + 16
Address fields to each (run) record, and as another MPV wrote on this forum,
records are cheap, fields are expensive, not to mention cludgy to work with.
If you you can help further and have the time, i would be happy to email you
the database to get a real feel for what i am trying to do.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DLookup in Continuous form 0
Two columns followed by single page-width column on same page 0
Paragraph numbering in Word 1
Split form 0
Clearing combo boxes and a text box 2
Two columns : Continuous two columns vs Parallel two Column 1
Dynamic Naming of Form Button 3
Hiding single items on a continuous form 3

Top