Form not showing data

[eggwater]

hi

I've developed this form that contains some cascading combo's.

They work fine and the data gets written to the master datasheet etc...

HOWEVER...

when I go back to the form - the data in the fields controlled by the cascading combos is NOT (always) VISIBLE for every record and when I choose the data again this treats this as an update and therefore effects my export code.

The data chosen by the Cascading Combo boxes has to be Visible it's very important.

please help i have to present this to a client today and this is quite a pain in the arse.

 

[eggwater]

I know this is something to do with refresh/requery

I've added me.refresh and me.requery to the 'on open' procedure on the form but this only seem to effect the first - as i cycle throughthe records they do not all refresh -


therefore I think i need a procedure that refreshes/requeries each record as it becomes the active record - I don't know where to put this procedure?!

 

[pono1]

I'm not sure if this is will be your solution but I am sure a form's On Current event fires when Access moves to a record.

Regards,
Tim

 

[eggwater]

yr right

I just figured that out myself

thanks though