Recent content by leem888

If I remember correctly, in the "extended" query, you are prompting for the [Enter Box#]. So each time you execute the query, it will prompt you for the value. Just a thought, but have you considered creating a comboBox for the Box #, and as you change between that, the comboBox for the...

will do. I'll update the thread once I'm finished.

just to bring you up to date, I thought I'd just simplify the process for the user and just add a refresh button that they would click whenever they felt they needed to refresh the Client Metrics table with records. The procedure would loop through the clients table, metrics table and client...

only yesterday when I was looking for code examples... what's the process for the approach?

here is the version I edited yesterday. I removed the box # field. nevertheless, is this what you were trying to accomplish?

yes I use 2007. What is the feature??? :)

:) Glad to know great minds think alike. I was afraid that was the approach I would have to take. Thanks for all your help vbaInet.

a little. just enough to be dangerous. :) what ideas do you have in mind?

thank you. I used the Northwind Template. when I'm on the main screen and selecting the checkbox in the subform. a record will be inserted into the client_metrics table, however without the clientID. I'm assuming since we removed the bound column from the client comboBox from the main form...

Here you go...

Yes. I do have that setup. I am able to add the records to the join table, however, the records are getting inserted without a parentID. Any thoughts?

Yes. but here is the kicker. (always a kicker) intially, the client will not have any associated metrics but should see all the metrics available. As the client checks off those metrics they want associated, the next time they come to this screen they should see the list of metrics, both...

Not sure what your intent was with the Box # field and continuously prompting for that value, but the list below should help you get the combo box and subform working. add CustomerID to your comboBox Row Source query. if CustomerID is your first column, make sure to change the Bound Column...

vbaInet - Thanks again for your response. I'll copy it below so all can benefit... *** I understand. In that case, can you post screenshots? I was struggling to understand your problem but after having another look I think I have a better understanding. Basically, your subform is linked to...

vbaInet - I understand I can control the filter. However, I don't believe either approach will resolve my issue of being able to see the total possible records that are available in the Child table as well as those already associated in the join table. ???