Updating Form

  • Thread starter Thread starter Charles Phillips
  • Start date Start date
C

Charles Phillips

Hello,
I have been an MS-Access 2000 database to manage, I need some help.
I have the following fields:

1. Service Available Combo Box Value List: a.) Cable;
b.) DSL; c.) None Available; d.) Ordered; e.) Not Ordered; f.) Satellite
2. Router Shipped Yes/No
3. Router Ship Date Date/Time
4. Shipper Tracking Code Text
5. Router Asset Tag # Text
6. Router Received Yes/No

If I select 1 c, or 1 f, I want fields 2-6 to be "grayed-out" & unavailable
to run in a query.
How can do this?
Will someone point me in the right direction???

Charles L. Phillips
 
You can't really do that in a query, but you can in a form.

On the AfterUpdate event of the Combo Box (and the
OnCurrent event of the form) use:


dim blnEnabled as Boolean
blnEnabled = cboService = "c" or cboService = "f"
RouterShipped.Enabled = blnEnabled
RouterShippedDate.Enabled = blnEnabled


Etc....


Let me know if you need more help.

Chris Nebinger
 
Back
Top