Automatic inputs

  • Thread starter Thread starter Iconoclast
  • Start date Start date
I

Iconoclast

Hello.

I am making a form wherein there is text box that would accept "year" and a
combo box of two choices, "annually" and "quarterly". Choosing "annually"
would produce only one line of input in the subform (datasheet). The
"quarterly" choice would produce only four lines in the subform (datasheet)
each line would have fixed dates: March 20, XXXX; June 20, XXXX; October 20,
XXXX; and December 20, XXXX. XXXX is the year inputed from the text box.

The subform has an underlying table.

Can anyone please help me?
 
Do you really need to input data which can be calculated? Think about it. If
the dates are constant, a single record can be put in the combo ("annually"
or "quarterly") which can link to a table with the date values and produce
the data as necessary. Unless there is additional data that needs to be
recorded on each line, you don't need to create all those redundant records.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top