Multiple use of combo boxes

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

Guest

My question is: can you use the sam combo box on a form multiple times with
control such that different items can be selected in the combo box.

The project I am trying to get to work requies that different analytes be
selected (from the combo box)and the results entered. What I need to do is
have the capability of being able results for multiple different analytes on
the same form. When I try this every time the combo box changes the change
is reflected in all of the other boxes on the form.

Hope this makes sense.

KN
 
My question is: can you use the sam combo box on a form multiple times with
control such that different items can be selected in the combo box.

The project I am trying to get to work requies that different analytes be
selected (from the combo box)and the results entered. What I need to do is
have the capability of being able results for multiple different analytes on
the same form. When I try this every time the combo box changes the change
is reflected in all of the other boxes on the form.
Click to expand...

You need to take a step back from Forms: you need to change your Table
structure. A Form does not contain any data; it's just a tool, a
window to let you edit data in Tables!

If you have a many to many relationship between whatever it is you're
analyzing and the Analytes, you need THREE tables:

Products <or whatever it is you're analyzing>
ProductID
<product specific fields>

Analytes
AnalyteID
AnalyteName
<other info about the analyte, such as perhaps a memo field
describing the analysis methodology or a hyperlink to a document
containing the process>

Analysis
ProductID
AnalyteID <<< joint two-field Primary Key
Result

You would have a Form based on your product table, with a Subform
based on the Analysis table; each record in the Analysis table would
be for a different product-analyte pair.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top