How do I set combo box's 'Enabled' property for current record only?

[dukwei]

Hello everyone,

I am starting to develop a database for work. I have a form called “Shipment Details”. Inside Shipment Details form there is a “Carrier” list box; I call it Carrier.
Carrier is followed by a dependent “Ship Method” combo box; I call this ShipMethod.

In Design View:
I set ShipMethod’s ‘Enabled’ property to false, via Properties, because I want it blurred out until a value in Carrier is selected.

In Form View:
Once I select a value in Carrier list box, ShipMethod becomes enabled, which is what I want. But now that I selected a value in Carrier, all records’ ShipMethod combo box is enabled! I only want “ShipMethod.Enabled = True” to apply to the current record only, not every single record, since the only current record’s Carrier list box has been updated.

In Carrier’s AfterUpdate property, this is what I have:

ShipMethod.Enabled = True


Does anyone know what I am doing wrong? I’m a total newb @ Access so I’m sorry for the stupid question. Any help would be greatly appreciated. Thanks.

I also attached a picture w/ comments for reference:
http://farm1.static.flickr.com/198/468619732_ae65cc6f1a_b.jpg

If there’s a resource that you think I will benefit from please let me know!

 

[RuralGuy]

You need to disable the ComboBox in the Current event of the form.

 

[dukwei]

thank you RuralGuy!

i put

ShipMethod.Enabled = False

in the OnCurrent event of my main form and it works great now. more stupid newb questions to come =P

 

[RuralGuy]

Great! You may still need to adjust it a bit for existing records but you are off and running.