I'm havent worked with access for a lot of years, now I'm in the need to create some new stuff. It's a bit hard to get back into it.
I have a form with a subform. Mainform is the main info of an order. Subform are the orderlines. One order can only come from one supplier. (selected on the mainform)
You can ofcourse add line to your order (or see what already is added on this order). The last thing is working and adding a new line is also not a problem. The thing is that I want the combobox of ArtId only exist out of articles you can order from the selected supplier in the mainform (filter? )
someone who can direct me in the correct direction?
thx
Wesley