Search results

Sweeet Well Dude, after much messing around with that example (an MDB paints a thousand words) finally got it to work. As I suspected, you did reference it via the control rather than the form. I've just spent the last 4 hours trying to figure out why it still wasnt working, only to find an...

OK, I tried that - if I understood correctly - what I did was set up a query which queries out the entire field set based upon a query criteria of CompanyID from the Companies Table - the criteria of WHICH CompanyID being pulled from the record being clicked on in LISTSUB. I then set up the...

... Looks promising Brad... It's bedtime for me..but by your leave I'll get onto it and see how we get on first thing in the morning :D Thanks.

Subform to Subform Problem Unfortunately I can't do that because there's other stuff going on in LISTSUB - ie I've got a flag down the left of each record in the list, highlighting the status of each company, plus there's a search field at the top to dynamically query out and find certain...

Hi, I'm only a beginner with Access and VBA (on a windows platform - Access 2000) etc so apologies up front. I have a main form (called frmMAININTERFACE), within which I've inserted a tab control item. Each page in the tab control thing is going to contain a subform, each subform relating to a...