
March 23rd, 2005, 03:44 PM
|
|
Registered User
|
|
Join Date: Mar 2005
Posts: 6
Time spent in forums: 2 h 41 m 55 sec
Reputation Power: 0
|
|
|
looking for vb script for this if/then
basically, i have a form (form2) in columnar format that has 5 columns: store name, version release 703, ver rel 705, 801,802,803...
store name will have data populated from table 1 (with no duplicates)
while the ver release columns will be check boxes
table1 has 2 columns: store name and version. with 289 records.
store 1, ver 703
store 1, ver 705
store 2, ver 801
store 2, ver 803
i want to match data from table1 to form2. and i need to get the code corrected
when form2 (used wizard to create from table2) opens, call data from table 1
if value in table1.column1 and table1.column2 FROM table 1 = value in form2.colum1 and "703" then
form2.chkbox1=true
else
form2.chkbox1=false
|