Record not retaining/storing combo box selection

[wordsmith]

hi,

i have a form that uses combo boxes for entry, some of the combo box entries are dependent on preceding combo box selections.

i have managed to make the combo boxes present options based on the previous selections, but am finding that after i move on to another record, some of the combo box entries are not being retained or stored in the record.

It happens only on some records and sometimes when I return to it again the selections are there even though on a previous ocassion they were not.

Can anyone suggest what may be causing this?

Regards

K

 

[ansentry]

Have a look at the attached sample, it should show you how they work. When the form opens go to a new record, and use the combo boxes to enter the data.

I have a couple of queries that demonstrate how the relationships work.

If you need any further help or explanation post back.

 

[wordsmith]

cheers for that! taking a look now

 

[wordsmith]

Ok, that was fine, i think the problem for me lies in the fact that my combo boxes are cascading and are dependent on the selection made in the previous combo box.

In the OnUpdate event, i have the Me.cbo.Requery expressions and i think it is doing this even after the selection has been made and i return to the form.

any suggestions?

 

[ansentry]

Post a copy of your db, make sure that you include the table that is receiving the data from the combos.

 

[wordsmith]

Hi John,

here it is, cheers for having a look

regards

K