Controlling a Continuous Form

  • Thread starter Thread starter ladybug via AccessMonster.com
  • Start date Start date
L

ladybug via AccessMonster.com

I have a Continuous Form where a user can select a "Yes" or "No" toggle
button to show acceptance. If they select "no," additional text boxes open
for the user to explain why it was not accepted. I made this a continuous
form because the user can come back at a later date and Accept it on the next
drop down form. The problem is when they select "yes," the previous form
where "no" is selected is now missing the reason why it was originally
declined. Can someone help me with a code that will eliminate this problem?
 
It sounds like you are saying you want to keep a history of the acceptance
actions. From your description, you are only keeping a single record, which
will show current status, but since there's only one, can't show history.

Or am I misunderstanding...?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
You can't enable, or hide ONE field on a continues form, since then ALL
FIELDS in that column will hide/or display.

I certainly have a lot of continues forms where I set the controls 'enabled'
property on/off. While this actually makes all instances of the control go
disabled, I actually find this works quite well. I mean, when you move
to the next row, those columns that you enable, or disable can then
be set. So, you could set the controls visible property as you move
the cursor up/down through the

In fact, I actually PREFER the above behavior, as then during
data entry it is VERY easy to see that the column in question
is enabled.

In place of a VERY HARD TO READ checkerboard pattern of enabled, and
disabled boxes,
, you get a very nice enable/display view as I move the cursor up /down.

I have uploaded a gif animation of me navigating in a form, both of the two
screen shots will give you an idea of how this looks.

http://www.members.shaw.ca/AlbertKallal/HideColumn/index.htm

Take a good look at the TWO forms above, and note the behavior.

In your case, this enable/display idea likely would not work. In fact, I
would suggest that you open up a new form, or use two forms "side by side",
so the form on the right side could show/display those additional fields you
talked about.

There is a series of screen shots here that shows some side by side forms
http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

The above screen shots of side by side forms shows how you can "open up"
more details for a single line of data in a continues form.
 
Back
Top