Carry over data from previous records

[Guest]

I know there are already posts here that deal with this, but I've tried their
suggestions without any success. Im a total noob at this so I'm sure its me.
I'm using Access 2007. I have a multiple items form (maybe thats the
reason nothing I've tried has worked?) that I'm using to track requisitions.
Basically an invoice. Each row is a supply with quantities and all that. I
have fields that Id like to remain the same for every supply I add to the
form. For instance, fields like "Control_Number", "Status", and "Vendor"
should be the same for every product entered at one time on this form, so
it'd be great if I could just enter them once. I separated all these items
into the form header for this purpose. Any suggestions? Thanks in advance
for all help.

William

 

[Jeff Boyce]

William

You described your form, but not your data. Everything starts with the
data...

I'm guessing, based on your description, that EVERY record has
Control_Number, Status, Vendor, ... fields.

But these seem like they are "Order"-level qualities, not something that
pertains to each line item.

Please post a description of your table structure...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

I had one table but worked on that a little yesterday. I have 3 tables now.
One with vendor information, one with all the order level constants and one
with all the product information or line items. I have 'vendor info'(one)
linked to 'order constant'(many) with vendor name and this relationship seems
to be working great. I have 'order constant'(one) linked to 'line
items'(many) with invoice number. This relationship seems to be giving me
some trouble, but I'm thinking thats because the multiple items form requires
me to put all the information in every time, and since 'invoice number' is my
primary key in 'order constant' (because if its working right, it should
never duplicate) its throwing up errors. Maybe I should be putting all my
line items in a subform? Thanks for your help.

William

 

[Pieter Wijnen]

you should use a subform ,yes

Pieter

I had one table but worked on that a little yesterday. I have 3 tables
now.
One with vendor information, one with all the order level constants and
one
with all the product information or line items. I have 'vendor info'(one)
linked to 'order constant'(many) with vendor name and this relationship
seems
to be working great. I have 'order constant'(one) linked to 'line
items'(many) with invoice number. This relationship seems to be giving me
some trouble, but I'm thinking thats because the multiple items form
requires
me to put all the information in every time, and since 'invoice number' is
my
primary key in 'order constant' (because if its working right, it should
never duplicate) its throwing up errors. Maybe I should be putting all my
line items in a subform? Thanks for your help.

William

 

[Guest]

Worked like a charm. Thanks a ton.

you should use a subform ,yes

Pieter