East Question for most of you

[Wes98765]

Hey guys,
I have two fields in a table one called time that is a drop down and gets its information from another table. The other field is dayofweek. I want to be able to select a time and have the dayofweek automatically fill in based on the time selected from the data in the other table.

Thanks for any help

Wes

 

[Shortie]

If the time field is a combobox, set the column count to 2 and bound column to 1. Set the source to pull the time and dayofweek. Set the widths to 1cm;0cm (thus hiding the 2nd column). Afterupdate of time combo, pass the dayofweek field the value from column 2 of the time combo.

...
'Column numbers in code start from 0
Me.DayOfWeek = Me.Time.Column(1)
... On On
Johnathan Perry

 

[Wes98765]

Thanks alot for your help!! Where do I add the code Me.DayOfWeek....

 

[Wes98765]

I set the dayofweek field to 0 width but it is still visible. That is ok I am just wondering what I am doing wrong.

 

[Wes98765]

Great I figured it out. Now I need to insert that information into table Data and thats it. I am not sure how to do that either lol.