Variable value attached to data on form

  • Thread starter Thread starter TVComputer
  • Start date Start date
T

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!!!
 
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 :)
*
 
Back
Top