Recent content by busybee

I'll end up with 36 subforms instead of 6! I'll give this one last try. I've continued to work on my database, but my subforms are multiplying like rabbits because I can't find a way to use a variable in my combo box row source filter criteria (see initial message). An answer to this problem or...

Syntax problem Thanks for your quick reply, Bob. I gave it a try, but I get an error message (which I have to translate back to English from French for you, so it may or may not sound familiar): "The expression entered has an invalid period (.) or an invalid exclamation point (!) or...

I have a main form with a "master" combo box, and on this form there is a subform with a dependent combo box. When I select a value in the master combo box, the values in the dependent combo box are filtered correctly. Everything works fine, but I would like to re-use the same subform in...

Solution to opening form to a specific record Thank you Roy, that works! I was confused about the code, since I "borrowed" it from a forum somewhere and don't really understand what I'm writing. (It's amazing how far you can get doing that - until you really need to know what you're doing).

Not quite there yet Thanks for your quick reply. After attempting what you've suggested, I find myself with (Filtered) at the bottom of my form window, but all the records are still displayed. And this also leads to a significant mixup in how the counter works - I'll spare you the details...

I am not a specialist, but am trying to create an application with Access 2000to manage our company’s orders. I have a table called ‘Service’ containing descriptive data on the type of service requested. This table is linked to several other tables, with ‘ServiceNo’ as the primary key linking...