Create Folder Bases on Two Fields

[moke123]

You have several lookup fields in your tables which will give you nothing but heartache. You should consider getting rid of them.

[dancaw]

Did you make all the changes I suggested above?


It worked as expected when I made these changes.

I must be missing something, the filter drop down is working, but then Contact name is missing on any previous record untill i reselect the client then correct contact reappears,
but then if i go to different record with different client, there related ContactID is Blank

See Video?

[kd2017]

In the subform, sFrmTenderClients, in the On Current event add code to requery cboClient.

This will allow you to select a contact for each client, BUT if you have contacts from different clients displayed at the same time when it requeries the contact combobox the contacts on unselected clients will disappear. This is because the underlying query filtered them out. If this will be a problem we might want to come up with a different UI strategy.

Maybe cboClient's rowsource should have a subquery that looksup *all* client's associated with the tender and filter using in IN clause. Does it make sense that a tender would even have multiple clients? of not then a UI redesign might be a good idea.

Et al., suggestions?

[accesstos]

So that is proof of what I wrote, I guess, but in a round about way?

Sorry Micron, I am not sure if I fully understand your original comment but, schematically speaking, I would say that the Dot (.) refers to the properties/methods into Object Browser and the Bang (!) refers to the objects of the Navigation Pane. Technically speaking, Dot refers to the properties/methods of the class of the object itself and the Bang refers to the objects of the object model that is part.

That's why the Banq is considered as late bound reference. Nothing has to do with variable/object declaration(s).

Please, forgive me for the off topic.