Hi.

My question is fairly basic.

I have a table of student information. On the form created from that
table, I would like to have 3 buttons, Open Reading Form, Open
Language Form, Open Mathematics Form. When any of those 3 forms are
opened, I would like it to display some of information from the record
on which I was working. From there I would like to add/edit data
which would then update the "Reading", "Language", or "Mathematics"
tables.

How can I do this? I've already created all of the tables and forms.
I built relationships between each form. Now I'm lost.

I know very little about d-bases and I have very little time to take a
class or go hunting for answers in a book. I'm not asking for anyone
to write my program, but perhaps someone that might have a little
extra time to help out an impoverished school district with a basic
database that would drastically help it's overworked, struggling
teachers.

I will probably have more questions. If there is anyone who might be
available to offer some assistance via AOL instant messenger or MSN
instant messenger please e-mail me at myelasticmind (AT) hotmail (DOT) com with
your screen names. Thanks so much.

Boy, tuggin' at the ol' strings with that "poor teacher" bit is really
unfair! ::grin::

Here's what I'd suggest. Depending on what version of access you have,
there might be different ways to do this. I'm getting familiar with access
2000 so I'll describe that one for you.

Open your main form (that loads your student information file) in design
mode. Opening your form in design mode should bring with it a toolbox
window (if not, see help for design mode toolbox). Make sure Control
Wizards (one of the top toggle buttons) is active and click on the Command
Button icon. Place the button icon on your main form and click and that
should start the wizard to install a new command button on your main
form(you can move it anywhere it's convenient after all this other stuff).
Follow the directions for that wizard. When given the option for what the
button should do, choose Form Operation from the categories listed and Open
from the Actions listed. Pick your first form (say...Reading Form) and
click on that name, then select "open the form and find specific data to
display" and select the 2 similar fields, then name your button and finish
up. Run the form in view mode to make sure it works okay. If so, do that 2
more times for your other files and it's a done deal.

I'm kinda new to this stuff myself, but that should work.

Now, if you send this back to the NG with corrections in red, you're in deep
trouble!

Hope this helps.
ron

"Sam DeRT" <samdert (AT) hotmail (DOT) com> wrote

Hi Ron.

I had to pull out the big guns with the poor teacher bit...I'm
panicking.

I forgot to mention that I've already gone through the button routine
that you described, but each time I clicked on the "reading form", it
still opened to a blank form instead of having the information from
the student information form. In theory, that should have worked. I
can't, for the life of me, figure out why it's not working for me. I
think I figured it out, though. If you're interested, this is what I
had to.

I had to open the "reading form" in design view. Then I had to go
into the fields that cross-referenced the information from "student
information", double click it, go into control source, go into the
expression builder, and select the fields from "student information."

Now it seems to be functioning. Go figure, huh? The wizard should
have done that. I don't know what I did wrong.

Don't worry, though. I'll be back!!!! School starts next Wednesday
and I need to get this done. I've only been working on it for 3
summers now. They shouldn't expect English teachers to do
programming.

Thanks again.

"Ron" <ronSPAMBLOCKERwest777 (AT) earthlink (DOT) com> wrote