OK, my cascades work... now what? (Probably simple)

[vangogh228]

I set up a database allows me to use Candace Tripp's 3-level cascading combo boxes within a form, and display the datasheet within the subform (Do I need that displayed?) But, now I want to be able to add notes to each of the selected activities. What I have is

First selection: Conversion (What kind of data conversion we're doing)
Second selection: Geography (Country of region to which it applies)
Third Selection: Step (Which step along the conversion process being referred to)

When I make entries into these fields, I get down to a single record in my table, shown in datasheet view in the subform. But now, I want to be able to enter a series of dated notes for the various steps as we encounter or initiate activity. I have a related subtable, but I don't know what to do to be able to make entry into it from this form. I know it is probably stupid-simple, but I am hitting a roadblock here...

Thanks for any help.

Tom

 

[Ukraine82]

Try making a blank field in a table(subform datasheet table).

Take a look at the attachment file. It doesn't have 3 cascading combo boxes, but it pretty much close to your question.

hth,

Michael

 

[vangogh228]

Thanks Michael. I'm not sure how to relate your database to this issue, though. I appreciate the llok, though.

All I really want to do is add notes to each of these records. Since there will be more than one note, they need to be in a subtable, of course. I just don't know how to make it so I can go from viewing a single record, like Candace Tripp's database allows, to actually making entry of dated activity notes into those sub-records from the form.

 

[vangogh228]

Pat:

Thank you... and thanks again to Michael for his help. I think, though, I have badly explained what I believe to be my poor understanding issue.

Since the fields in the main form are "unbounded," how do I link the subform with the entries on the main form? After making those three entries, I am down to a single record which has an autonumber key field, which is great. But, that record display, along with that autonumber, is in the subform which I don't think is even necessary. The only things in the main form are the three entry fields. So, now I need to use the values in the three unbounded fields to get to the link from my main table to my subtable, which is through the autonumber field of the main table.

Thanks again for all the help. This has been a real headache... and probably for very little reason.

Tom

 

[vangogh228]

Fixed it

I was able to come up with a solution... it may not be THE solution, but it is A solution.

I wrote a query on my main table and set the criteria for each of my three fields to be the entries in the fields from the main form. Then, I based a subform in form view on that query and set all the fields to "no" for the visible property. I then created a sub-subform from my dated notes table and put that in continuous form view, sizing it to match its parent so that I wouldn't have any extra lines all around my form.

Works fine. I am now able to enter notes for my chosen record from my cascading combos in the main form. I don't like this solution, but it works.