I'm new to Access and need some advice. I am trying to setup a database to
print labels and reports for our shipments. I have set up a table with
fields such as

I have taken a snapshot of what I would like to do:

http://www.chadworld.com/images/form.jpg

All of these fields are in a table called: Ship_Info

I would like to type in the Destination, Load ID, Ready to Ship, Ship Date
and BOL# at the top of the screen, and, I would like to type in information
for a list of boxes associated with the Load ID at the top in the middle
subform. I would like the Destination, Load ID, Ready to Ship, Ship Date
and BOL# at the top to also transfer to the Ship_Info table without having
to retype them for each box I type. I would like to scroll with the bottom
record control through the Load ID at the top and have it show each list of
boxes for that shipment. I might be working on 2 shipments for the San
Diego called SD1 and SD2. I would like to flip back and forth between them
on the form so I can add more boxes as needed.

I saw something similar to this in another database I was looking at, but it
was using multiple tables. It was using forms and subforms, but I'm not
sure how to set the Link Child and Link Master properties.

As I said, I am very new to Access, so I might not be on the right track at
all. If you have an alternate suggestion, please let me know. I don't know
much about programming and have been trying to mainly use menus and the
expression builder. Any help would be greatly appreciated.

Thanks,

Chad

Chad:
You are on the right track.
You can use the master/child link to get the subform to link to a
record in a master table in the top form.
If you don't want to do it that way then you have to use code.

Base the form on your ship info table.
Have the wizard generate it as tabular. Do not use "datasheet"

The form header is where you will place your boxes.
You would use the after update event to flip between your 2 shipments.

code is something like this:

me.filteron = false
me.filter = "Load_ID = " & me.txtLoadID
me.filteron = true
You need to learn about events and some basic code to make Access to
what you need it to do.

You can use the before update event of the form to populate new
records with the contents of the form header boxes.

If you've never written code this is fairly easy stuff to start with.

Good luck
Ira Solomon


On Tue, 22 Mar 2005 22:53:20 GMT, "ChadDiesel"
<shaqattack1992-newsgroups (AT) yahoo (DOT) com> wrote:

I appreciate the help

Thanks,

Chad


"Ira Solomon" <isolomon (AT) solomonltd (DOT) com> wrote