Enter Data In Subform

[accessuser1308]

I currently have a db with several tables/subtables. I would like to create
a form/subform based off of two of these tables. The main form would contain
information that would relate to all samples that will be stored in the
subform.

The subform will be linked to the main form using a common ID field. For
each main form there can be up to 100 samples in the subform. These samples
are actually stored in a box that is 10 positions by 10 positions. Is there
a way I can create the subform such that I can have a 10x10 "grid" that will
show the samples in their physical position within the box (ie location A1,
B5, C4, etc)? I would like the subtable to contain only two fields...the
sample name and the location. I figured when one of the grid locations was
filled in it would automatically assign the location (I can do this using
VBA). My problem is if I put 100 text boxes all linked to the same sample
field when I populate one box it will populate all of them.

Is there a way/better way to do this? Thank you for your help

 

[Peter Hibbs]

A Flex Grid Control will probably do what you want but you will need
to write a bit of VBA code, have a look at my Flex Grid Demo program
for some examples. You would use the flex grid control instead of the
subform in this case.

Go to http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=180

HTH

Peter Hibbs.

 

[schasteen]

You will not be able to do this using a bound form. You will have to do an
unbound form and write code to handle loading, saving, changing, and deleting
the values.