Pass value from Form/Master form to second Form or SubForm

[DaveMeadows]

Hi All,

I'm currently building a stock database which will include a form where you can book in stock deliveries to the database.

The table contains the following fields: ID, Roll Number, Roll Length, Date Received, PO Number etc.

A single delivery may contain multiple rolls so the PO Number and Date Received will all be identical, but the Numbers, IDs and Lengths will be unique.

I don't want to have to repeatedly type repeat data so I would like a Form where you can enter the repeated delivery details in one section, and then a second Form or SubForm where the unique data can be entered.

I've tried setting the data fields where values are repeated to look at a single source field for its value (which looks fine within the form itself), but these values aren't saving themselves to the table. The only values that save are the ones that I manually enter.



Any ideas?

[pbaldy]

How about this in the after update event of the control(s):

http://access.mvps.org/access/forms/frm0012.htm

[DaveMeadows]

Will give it a go! Thanks for your reply.

In the meantime I've also had a brain wave redesigned my table structure so that I have one table for repeated data that links to a second table containing the unique values. This also worked and I guess is actually better practice in terms of data management and memory usage!

[pbaldy]

If you mean like an invoice header table and a separate table for detail items linked by invoice number, yes that would be a better design than everything in one table.