Recent content by MrChameleon

Hi, I have an Access 2010 DB with a specific form on which there are 9 combos. I have a button I want greyed out until all of the combos have a valid selection made. I've played around with a couple of ways of achieving this, such as a crazy IF not (isnull(cmb1)) and (isnull(cmb2))...etc...

So I guess I'm going to have to resort to forcing the form I want with SetFocus and then just the generic Docmd.Close, which works. It's as soon as I insert the name of the form that Access just completely ignores the line of code. As I say, 2 completely different machines, 2 different vanilla...

Thanks again for the reply Steve. So, I have two computers, both running Access 2010. I have created a blank database on both, created two forms, form1 and form2. Form1 has a cmd button that opens form2, form2 a cmd button that closes itself, using "docmd.close acform,"Form2". It doesn't...

Apologies for not being clear enough and thanks for the replies. So the form closure thing; if I specify the name of the form in quotes as per my example, it just doesn't do anything - the form stays open, no error is triggered. If I leave the form name out, the current item closes. Usually...

Hi. Two quick queries... First, I can't understand why the following line of code doesn't work? DoCmd.Close acForm, "frmProgressWindow", acSaveNo Second, I have a form with a Listview on it and several buttons which call other forms which change dtata sets that could influence the data...