Linking unbound Boxes?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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,...)
 
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.
 
I don't know if you read my reply or not. You didn't seem to answer any of my
questions.
 
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
 
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?
 
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
 
Back
Top