Setting up a check box

D

Dave

I have put a logical field in a base table with a check box on the relevant
form. Now if I check the box on the form them the check tick remains there
in place when I moved to an other forms. The logical check has only been
added to the relevant record, but appears on all forms regardless.
How can I make that check relevant only to the form in question?

Dave
 
V

Van T. Dinh

That's not the normal behaviour unless I misunderstood your description ...

Were "other" Forms created (by using Wizard) after you had added the Boolean
Field?

Describe step-by-step what you did in chronological order ...
 
D

Dave

Van T,
Thankyou for your reply. I have used incorrect terminology, I said that the
check appeared in other FORMS, I should have said in other Records. That is
when the check is made on say record 1, them you move to say record X, then
the check mark is as was left in the previous record, if it was left as set,
then it will show set in the next opened record (s) and visa versa.
I trust this makes it clearer to you.
It seems that maybe I should have some code in the update as maybe Requery,
etc, but I am only guessing.
Your futher help will be greatly appreciated,
Dave
 
V

Van T. Dinh

Sorry, I am not following the rest of your description besides the fact that
we are talking about a single Form and your question related to the
navigation on this Form.

Please answer each question clearly & separately:

1. Is the CheckBox bound to the Boolean (Yes/No) Field in the Form's
RecordSource?

2. Let's say that you look in the Datasheet View of the Table and you found
the value of this Field is True (checked) for Record 1 and False (unchecked)
for Record 2. You then check the Form by navigating from Record 1 to Record
2. What do you see in Record 2?

3. What do you want to do if the user checks or unchecks the CheckBox?

4. What happens if the CheckBox is currently checked and the user navigates
to another Record in the current set-up? And what do you want to happen?

5. What happens if the CheckBox is currently unchecked and the user
navigates to another Record in the current set-up? And what do you want to
happen?

My guess is that the CheckBox has not been bound to the Field as yet ...
i.e. The ControlSource of the CheckBox is empty while it should have been
the name of the Field.

Note that if you use a Query or an SQL String as the RecordSource for the
Form, you will need to modify the Query / SQL String to include the added
Boolean Field since the added Field won't go automatically into the Query or
the SQL String and hence, it will not be available in the Field list of the
Form.

If you use the Table as the Form's RecordSource, the new Boolean Field will
be automatically added to the Field list of the Form.
 
D

Dave

Van T.
Thankyou for your further advice
The checkbox on the form was NOT linked to the base form. It is now linked.
All appears to be function as I want it to function. I have run your check
sequences and the base form shows the actual logical state throughout each
test change.
This data is held by a Qry which passes same to a report form, ie - no check
then no entry on the report and subsequent label printer.

Thankyou very much for you time and patience. I should have picked this up,
two heads are nearly always better than one aye?
The other problem with the filter sort, I cannot fathom it. I call the form
simply by clicking on a file icon, **.mdb, and the switchboard appears and
I further clk on a sw/b entry, with either a open in edit mode or another
open in add mode.
I will study your email further,
many thanks,
Dave

[email protected]> wrote in message
 
Top