automatically add another field when entering

M

Melody

Hi,

Using Access 2000

I know I've done this before and I just can't remember how.

I have a field called Product in a form. With some suppliers there may be
more than one product. What I would like the form/field to do is, as I type
into that field, another identical field appears below it so I can type in
another product for that supplier. Make sense? I know it wasn't too
complicated or I wouldn't have been able to do it the first time. Can anyone
help?

Thanks.
 
W

Wayne-I-M

Not really how that would be done on a sinlge form. I think you may be
thinking about a sub form set to continous. ??

If you possition it carefully and remove the border it would give the
appearence of what you say. You would still need to the link field in the
subform but this could be set to visible = No
 
M

Melody

Ok. How would I set that up?

Wayne-I-M said:
Not really how that would be done on a sinlge form. I think you may be
thinking about a sub form set to continous. ??

If you possition it carefully and remove the border it would give the
appearence of what you say. You would still need to the link field in the
subform but this could be set to visible = No
Click to expand...
 
A

Arvin Meyer [MVP]

I think you are looking to create a subform. From the form design window,
open the toolbox, make sure the wizards are turned on (wand selected) and
click on the subform tool, then place a subform on your main form and follow
the wizard's instructions.
 
Top