Command button wizard won't open related form

[Guest]

In previous versions of Access I could place a combo box on a form (populate
with a query) and then use a Command Button to open another form related to
the value selected by the user from the Combo... e.g. user selects a Customer
from the combo, clicks the command button and we open the associated Customer
form.

The wizard would ask how the two forms were related - it would list the
Combo for one of the forms and then list the fields on the customer form as
the second form. You would select the Combo from one side and CustID from
the other (Customer form).

The 2007 wizard gets to that same step (everything looks the same), but
lists NO data on the form that has the Combo. It's as if the combo doesn't
exist. If you attempt to code it as an embedded macro, writing the Where
clause, you can select a customer from the combo, hit the command button and
it opens a blank customer form!

I'm teaching Access to freshmen business students. I'd rather not have to
say that we need to work around the wizard as early as week 4. The whole
process looks exactly the same - except for the failure of Access to list
what's on the first form.

Thanks for any help

Mark

 

[Guest]

This may not be your problem but it is a possibility. Access 2007 will
disable VB code if the source file of the database isn't a "Trusted" file.
You can create code (which is what happens when you use the wizard), but it
won't actually run. If you go to the Office button in the upper left corner,
then go to Access Options, then to the trust center and add your source file
to the list.

This might solve your problem

HTH

 

[Guest]

Thanks for the suggestion - I added the folder to the trusted sites and it
has made no difference - the wizard still fails to list any controls on the
form that has the Combo...but DID do that in earlier versions.

Thanks again!

 

[Guest]

In previous versions of Access I could place a combo box on a form (populate
with a query) and then use a Command Button to open another form related to
the value selected by the user from the Combo... e.g. user selects a Customer
from the combo, clicks the command button and we open the associated Customer
form.

The wizard would ask how the two forms were related - it would list the
Combo for one of the forms and then list the fields on the customer form as
the second form. You would select the Combo from one side and CustID from
the other (Customer form).

The 2007 wizard gets to that same step (everything looks the same), but
lists NO data on the form that has the Combo. It's as if the combo doesn't
exist. If you attempt to code it as an embedded macro, writing the Where
clause, you can select a customer from the combo, hit the command button and
it opens a blank customer form!

I'm teaching Access to freshmen business students. I'd rather not have to
say that we need to work around the wizard as early as week 4. The whole
process looks exactly the same - except for the failure of Access to list
what's on the first form.

Thanks for any help

Mark

 

[linda fletcher]

I also have problem with the open form command button wizard - no fields are recognised to match with the key field on the table in the form that is to be opened - it can be hard coded in vb , but I teach gcse and the wizard should work

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com