I'm fairly new to Access, so please have patience...
I have an application that I've written to audit all of our computers, monitors etc. which also works-out the Intel processor details from the core speed and processor technology (eg. Pentium D).
I also have a field which calculates a "Score" based on RAM, CPU, HDD and FSBs.
I have two tables, Asset and Computers:
Asset contains the ID, department, user, category, make, model, serial, purch cost, purch date, invoice, disposal date and any additional values.
Computers contains the Name; McAfee Agent version; OS Vendor, Version, SP; CPU Type, Core Speed, No. Cores, No. Threads, FSB, Code Name; RAM, FSB; HDD; Office Version; VNC; Asset Number (ID); and Score.
To match these two tables, I have two forms, the Asset form is the parent, the Computers form is the sub-form.
What I'd like to do is somehow change the sub-form's Enabled property to False when the Asset.Type is not Notebook or Computer, but there is no Enabled property. How do I go about doing something to this effect?
I have tried to Dim the sub-form to a variable and set the form's controls' Enabled properties aswell to no avail.
I'm also trying to create a search tool - I have a button which should DoCMD.FindNext for txtSearch.Text in the field defined by what is selected in a combo box. That don't work iether.
PLEEEEASE could someone help!
Many thanks in advance!