Is it possible to convert a drop down number list to a negative?

[shabbaranks]

Hi all..



I have a drop down list which contains numbers. On occasion I migght need to add a negative number to a subform from the drop down list. Is it possible to insert a tick box which can active as a trigger which turns the number in the list to a negative number?

Thanks

[ajetrumpet]

no you can't turn the number into a neg, but what you can do is check the tick box for TRUE on the event that you're doing an activity on.

if it's true change the numeric to a neg in the code that you're currently using.

[shabbaranks]

The event that the activity is to be applied to is just a list from a table, so there's no code involved. Is this still possible?

Thanks

[Toyman]

The event that the activity is to be applied to is just a list from a table, so there's no code involved. Is this still possible?

Thanks

Give us an example of what you are trying to do. Once you select a value from the combo box, what happens

[shabbaranks]

Ok so an example is hours are from 0.5, 1 up to 10. I have created a query based on the hours table which makes them all negative. What I am now trying to do is give the user an option to select positive or negative values from the 2 different tables within the combo box - have I explained myself right?

Thanks

[Toyman]

Ok so an example is hours are from 0.5, 1 up to 10. I have created a query based on the hours table which makes them all negative. What I am now trying to do is give the user an option to select positive or negative values from the 2 different tables within the combo box - have I explained myself right?

Thanks

So, what you are trying to do is to be able to enter -2 hour, etc into the field? If this is so, then create the option box for negative. In the after update event for the picklist, put the following.

Select Case Me.YourOptionBoxName
Case True 'is negative
Me.YourHourEntryFieldName = Me.YourHourEntryFieldName * -1
Case False 'is Positive
Me.YourHourEntryFieldName
End Select

[shabbaranks]

Im either mi-understaing you or your mis-understanding me. Im not entering from a field, its from a drop down list as per here

http://imgur.com/aVLJx

I have 2 tables one with positive lists like the one above and one with negative lists as per here:

http://imgur.com/wiDqX

Is there a way via a check box or something where I can switch the combo box between the two?

Thanks

[Toyman]

Im either mi-understaing you or your mis-understanding me. Im not entering from a field, its from a drop down list as per here

http://imgur.com/aVLJx

I have 2 tables one with positive lists like the one above and one with negative lists as per here:

http://imgur.com/wiDqX

Is there a way via a check box or something where I can switch the combo box between the two?

Thanks

Ok, you could do this in the after update event of the option check box.

Dim Mysql as string

Select Case Me.YourOptionBoxName
Case True 'positive value
Mysql ="Select YourValueFieldName From YourPositiveTable"
Case False 'Negative Value
Mysql ="Select YourValueFieldName From YourNegativeTable"
End Select

Me.YourComboBoxName.RowSource=Mysql
Me.YourComboBoxName.Requery