form w/o subform

[vivian]

i need a continuous form for my order schedule, so i cannot use a subform.

I have 3 "subtables" and 1 main table.

I made a subform for each of the subtables that opens with a button from the main table.
(in each of these tables there is a [complete] yes / no button

i need something to show on my main table when the subtables have all of their records marked complete.

Any ideas?

 

[GumbyD]

You are going to need some code that will fire with the "on Current" event of the main form. The code will need to call the dataset for the subform and loop through the records to see if they are complete (not sure what that will mean to you - some fields populated or something). Have the function return a 1 or 0. 1 if the records are complete 0 if they are not. Then you can turn a control for completion on or off based on the results. I have used color and text changes to show completion. You may have to play around with the event properties to get it fire when you close your dependent form depending on how you are set up.

Good Luck!

GumbyD