Variable value attached to data on form

[TVComputer]

I posted earlier this morning, and didn't get much of a response, so I
think I'm going to try what I was trying a different way. Here's what
I would like to try and do: For each entry I have variables that will
change according to the entry. For example, Record A will select
DataA, DataC, DataD, DataG, then for each of those I would like to put
in a variable value. Then, show them on my record form to look
something like this:

RECORD A
DataA = 5
DataC = 20
DataD = 7
DataG = 1

RECORD B
DataA = 1
DataB = 10
DataH = 5

I was thinking about using combo boxes to multi select DataX, the
suggestion I got was to use mulit select list boxes instead. I have
combo boxes set up right now that work in selecting multiple choices
from the list (ie, DataA, DataB, DataC, etc). My problem is trying to
attach a variable value to that data for this entry only. I'm not
opposed to changing around what I have since I am just starting out
with a new database. Would an input box be the way to go???

Any suggestions would be greatly appreciated!!!

 

[Crystal (strive4peace)]

it would help if you gave us some idea of what you are talking about <smile>

I looked up your other post to find out they are items on a customer
record such as camera, computer, tv, etc

rather than different fields for each item they want, you should have a
related table with one item per record. Are these things they are ordering?

For better understanding of the basics of Access, read this:

Access Basics by Crystal
http://www.AccessMVP.com/strive4peace
free 100-page tutorial that covers essentials in Access


Warm Regards,
Crystal
remote programming and training

http://www.YouTube.com/user/LearnAccessByCrystal

*
have an awesome day
*