ACC2000 Copy chosen date to multiple tables--Coding...or query?

[BrentDA]

I have a combo box drop-down list in a form, with custom date ranges
(manually keyed in to a table), e.g., Jan 1-3, Jan 4-10, Jan 11-18.

When the user selects a date range (and enters some numeric data in fields)
on the form, the user then clicks one of 3 buttons to go to a selection of
more forms to key in more numeric data.

What I'm looking for is to have the selected date range copied to a field in
all the subsequent forms/tables as a new record (because all the forms will
have numeric data entered each time the database is used.

I need the selected date range (from the initial form) tied to each new
record of numeric data entered. I'm doing this to eliminate the added work
of having to select the date range on each form, and also to avoid the
possibility of user input error.

I have it set up now so there is a 'hidden' date range field on each form
that the users don't need to see, but I can't get the date range to 'copy' to
all the forms/tables.

Would I use coding, or set up a query to update the date range field in all
the forms/tables? How would I go about doing this, I'm still on a learning
curve with coding/queries, so a little explanation of how the coding query
works is greatly appreciated !

Thanks in advance for your help !

Brent

 

[Duane Hookom]

If I understand correctly you want to take the value entered into the first
form and use it as a default in controls on other forms for new records. If
this true, you can keep the first form open (could be hidden) and set the
Default Value of the text boxes on the other forms to something like:
=Forms!frmFirstFormName!cboCustomDateRange