A little help

[ckeezer]

Here is the skinny:

tbl_tc contains these fields:
id (linked to tbl_tcadmin.id)
user name
user id
site location
tag #
tag #2
equip type
date of call
issue

tbl_tcadmin contains these fields:
id (linked to tbl_tc.id)
tech name
trouble shooting
resolution
date of resolution

frm_tc
all of the above fields.

PROBLEM:
I need for the form to display the records from each table based on the ID for the record. the reason I did this is beacuse Access does not allow for field-level permissions to be set. I do not want my users to be able to manipulate the data on tbl_tcadmin, hence why I created 2 tables vise one.

I just need a point in the reight direction to clear my mind of the garbage that is in it right now.


On another note, I am trying to populate tag#2 and equip type from the selection made in tag# (this is a combobox). Current code is easy:

Private Sub Combo30_AfterUpdate()
Me![tag#2] = Me![Combo30].Column(1)
Me![equip type] = Me![Combo30].Column(2)
End Sub

Problem is that I only want to display one row of data under tag#, when I set the columns property to 1, it will only populate infor from the first column not the 2. If I set the column count to 3, then all works fine.... I would like to not see 3 columns of info though.

Any quick tips on resolving that would help,
chuck

 

[RuralGuy]

Maybe MVP Allen Browne can offer some useful suggestions.

 

[ckeezer]

read the article he has on enabling/disabling controls, based on User Security.... I am getting all sorts of errors... with regards to the first line of code:

If mainswtich board form has buttons to add, edit and report on records,you may set up a workgroup of accounts that may only report, called viewers.

To disable the add and edit buttons use the OnOpen property of the mainswtich board form to run the following:

if condition: [Forms]![usersform]![workgroup]="viewers"

setvalue: [Forms]![mainswitch]![reportsbutton].[Enabled] Yes
[Forms]![mainswitch]![addbutton].[Enabled] No
[Forms]![mainswitch]![editbutton].[Enabled] No

if says that it cannot find [Forms]![usersform]![workgroup], which is true because I do not have a form called that. I changed it to my form (frm_tc) and it gives me error:

cannot find field [workgroup]....

What on earth am i doing wrong?

 

[RuralGuy]

I'm sorry Ckeezer, I have not personally used this code of Allen's. All I know for sure is that Allen has been at it for many years and knows what he is talking about. If you want to use his suggestions then I would study his sample db to learn what he is doing. Sorry I can't be more helpful.