Newbie: Updating a combo from another combo

[mr_sd]

I'm a bit of a newbie at this. I've only ever done quite basic access.

My prob:

I have 2 combo boxes.
The first - [G1S] (game one start)
The second - [G1E] (game one end).

The combo looks up from a table which contains time slots 10.00 10.20 10.40 11.00 11.20 etc up to 22:20

A game is by default 20 mins long. I would like the [G2E] field to have a default value 20 mins later (i.e. the next item down on the list). I have tried playing with the ItemData command but with no luck.

Thanks, Rich.

 

[Pauldohert]

I am assuming each combo box is two columns - a timeslotID and time

ID Time

1 10:00
2 10:20
3 10:40

in the after update event of combo1 put

combo2 = combo1.value + 1
combo2.requery

you will have to account for the last start time not having a 20 min later finish time - if you have not alrady done this

 

[mr_sd]

Sorry probably me being thick but now it says "Microsoft access could not find the macro G1E = G1S"

 

[Pauldohert]

In the properties of the combo G1E

In the after update option select event procedure and then the ... button to enter your code

Then

Private Sub GS1_AfterUpdate()


Me.GE1 = Me.GS1.value + 1
Me.GE1.Requery

End Sub

Your are trying to set the end time,GE1?

 

[mr_sd]

Great. All sorted. Thanks for your help!