Help With A Form

  • Thread starter Thread starter Jimmy
  • Start date Start date
J

Jimmy

Hi, folks. I had no idea groups like this existed until yesterday. I
guess I've been living in the dark ages.

I am trying to design a form where some fields will be hidden until
they are needed. For example, there will be a field for a date and a
field for type of inspection. Periodically both fields will be
updated, preferably in fields directly below the origanals. I would
like to have a column of at least 10 fields below each original field
to be used as they become necessary, but that would not show up on the
form until they are needed. Is this even possible? I ran it by our
IT people and nobody knew. I designed the form with a column of 10
fields but all 10 fields show and it looks bad. Can anyone help?

Thanks your help.
Jim
 
Jimmy said:
Hi, folks. I had no idea groups like this existed until yesterday. I
guess I've been living in the dark ages.

I am trying to design a form where some fields will be hidden until
they are needed. For example, there will be a field for a date and a
field for type of inspection. Periodically both fields will be
updated, preferably in fields directly below the origanals. I would
like to have a column of at least 10 fields below each original field
to be used as they become necessary, but that would not show up on the
form until they are needed. Is this even possible? I ran it by our
IT people and nobody knew. I designed the form with a column of 10
fields but all 10 fields show and it looks bad. Can anyone help?

Thanks your help.
Jim
Click to expand...

I'm not sure what you have in mind, but it sounds like a main form (for
the non-repeating data) with a continuous or datasheet subform for the
inspection dates and types. Since the inspection information is
repeating data, you must have a separate, related table in which to
store, with a record for each item/inspection date/inspection type.
Then, you see, the subform shows only the inspections you've actually
entered for the current "item" (whatever it is) on the main form, plus a
blank line to enter a new inspection. You can also set it up so the
blank line doesn't show until you click a button.

Does that sound like the sort of thing you're looking for?
 
Dirk Goldgar said:
I'm not sure what you have in mind, but it sounds like a main form (for
the non-repeating data) with a continuous or datasheet subform for the
inspection dates and types. Since the inspection information is
repeating data, you must have a separate, related table in which to
store, with a record for each item/inspection date/inspection type.
Then, you see, the subform shows only the inspections you've actually
entered for the current "item" (whatever it is) on the main form, plus a
blank line to enter a new inspection. You can also set it up so the
blank line doesn't show until you click a button.

Does that sound like the sort of thing you're looking for?
Click to expand...

That sounds exactly like what I want to do. I knew there had to be a
way but I was clueless as to how. Thanks a lot for you help.

Jim
 
Back
Top