Linking unbound Boxes?

D

dls25

I have a form with 100 unbound boxes, in center of form. On top is a row
numbered 1 to 10, on left side A to J. (Makes a big box.) In this form I also
have three combo boxes: Tank (1 to 2), Rack (1 to 24) and Box (1-13, In each
box it has 100 Spaces), which I want to link to the unbound boxes by putting
a Pt number in that space. I tried a qry, put I get duplicate numbers that
way. I linked the combo boxes with the table, that works but how do I place
the associated Patient number in the unbound space to link?

dls
 
D

Duane Hookom

You haven't stated:
-how Pt Numbers are related to anything else
-how/if you have given your 100 text boxes any kind of naming pattern
-what your data looks like
-what your rows and left side are (text box, combo box, label,...)
 
D

dls25

These unbound boxes are like one big box that I put samples in. There may be
one patient with up to 4 little vial, that I put in this box. I want to keep
track which vial is where in the box. In my main form I have lookup tables
called Tank, Rack, Box and Space. The tech in the lab enters this information
in the form, then stored in the database. The lab tech. wants a visual. Each
Patient has an special number and Vial number, the vial number is what I want
to enter in these unbound boxes.
 
D

Duane Hookom

I don't know if you read my reply or not. You didn't seem to answer any of my
questions.
 
D

dls25

Patients are linked to a Special number , other information and a cryo box -
space location. each Vial that goes into this box has a number also. I want
to place a number (6 numbers long) in these unbound box, up to a hundred
different numbers.
My form looks like a square with lots of little squares in side this area.
Then Will look at it and I can say that in 1A is numer ### and this relates
to a patient. I don't know how to say it any better.

Diane
 
D

Duane Hookom

You still haven't provided:
-how Pt Numbers are related to anything else
-how/if you have given your 100 text boxes any kind of naming pattern
-what your data looks like
-what your rows and left side are (text box, combo box, label,...)

Have you created the form yet or are you looking for ideas? Can you please
share your table structure?
 
D

dls25

Each Pt has a special number. The Pt sample has may tests run on the sample.
The sample is stored in a box (with 100 spaces) in a negative 100 degree
refrigeration for later use. Each sample is given a special number, this is
what I want in the unbound boxes. 1-10 and a-J are labels = 1a,2a,3a
ect 1a,2a,3a
dls
 
Top