Sure It is very simple Yes/No

[easedaway]

Hi,



I'm a novice Access user having had the need to use it thrust upon me.

Currently I am cataloguing an article library so I've used Access to create tables and forms for the sections of the library and a sign out sheet.

Now what I want and I'm sure it is easy but I don't know how to do it is; when I fill in the sign out sheet for an article the catalogue sheet automatically updates to say that the item has been checked out and the same for when it comes back in, I tick a box to say that it has been returned and it shows that they are back into the library

I hope this makes sense and someone can help me out.

Cheers

[Robeen]

In your table that has all the articles, you could have a field that is a 'Yes/No' field and name it something like 'CheckedOut'.

Then - if you are using a Form for your 'Sign Out Sheet' - you could add a Check Box control to the Form and 'bind' it to the 'CheckedOut' field.

When you fill out the Sign Out Sheet - you can check the check box and that will tell you that the article is checked out.

Does that help?

[easedaway]

That is exactly the sort of thing that I am after, now and really sorry for the stupid question but how do "bind" the control button?

[Robeen]

There are no stupid questions. Just feel free to ask what you don't know.

Once you've added the Yes/No field to your table:
Open your Form
Look up at the top of your page and you will see a button named 'Add Existing Fields'.
If you click that, you should see your 'CheckedOut' field.
If you double-click the field - it will add a control to the Form and the field & the control will be bound to each other.
You can also drag the field from your field list onto the Form.

All the best!

[easedaway]

Thank you! That seems to have cleared all that up and will now stop me having to duplicate work!

[Robeen]

Happy to help!!