Works in Database View but not in Switchboard...

[breadcrumbtrail]

Hi,

I'm perplexed. I have a form designed to access a certain table, which it does absolutely fine when I'm looking at it in the database view (if thats the correct term... I mean where the objects are listed down the left, 'tables' 'queries' 'forms' etc.). Seeing that it worked, I linked it in to a button on my switchboard which I had already designed. But now, when I follow the macro through on the switchboard, it can access no records from this table! I get the feeling I am doing something really stupid as to why it wont let me see whilst going through the switchboard, any ideas?

Many thanks,

- John

 

[o1110010]

.. in the database view (if thats the correct term... I mean where the objects are listed down the left, 'tables' 'queries' 'forms' etc.)

Hellooooooo!

Right-click the form
Click Design View
Open up the form's properties (View -> Properties) if it doesn't already show them.
Click the Data tab.
Is Record Source empty?

 

[breadcrumbtrail]

Hellooooooo!

Right-click the form
Click Design View
Open up the form's properties (View -> Properties) if it doesn't already show them.
Click the Data tab.
Is Record Source empty?

Hi, thanks for your reply!

Record Source has the table name "Questions", which is correct. I'll put in a bit more detail about the form to see if that helps. The form itself refers to 2 tables, "Questions" and "Answers". When the form is opened (in database view at least), a particular record from Questions is pulled up and displayed. There is an option to open a new subform to answer the question if it has not already been answered. Could there be another problem that i'm overlooking?

Many thanks,

- John

 

[R6Flyer]

If you can view the form without problem straight from the database window but it doesn't launch from your switchboard then it is most likely a problem with the code or macro that sits behind the button on the switchboard.

What does the code/macro look like? If you post that info here you will probably get an answer to your problem.

 

[breadcrumbtrail]

If you can view the form without problem straight from the database window but it doesn't launch from your switchboard then it is most likely a problem with the code or macro that sits behind the button on the switchboard.

What does the code/macro look like? If you post that info here you will probably get an answer to your problem.

I've created the link through the switchboard manager, i'm not even sure how to pull up the actual macro or code. On switchboard manager, the particular item has the properties Open form in add mode, and then the Answer Question form to open, which as far as I can tell is correct.

 

[Navyguy]

I was just wondering if the event procedure or macro is selected for the OnClick properties of the button. or maybe the form is set to data entry...

Navyguy

 

[breadcrumbtrail]

I was just wondering if the event procedure or macro is selected for the OnClick properties of the button. or maybe the form is set to data entry...

Navyguy

Thank you! Yes, my form was set to data entry, i've changed that now and its all working. Thanks very much, you've saved me a huge headache!

Many Thanks,

- John

 

[R6Flyer]

I've created the link through the switchboard manager, i'm not even sure how to pull up the actual macro or code. On switchboard manager, the particular item has the properties Open form in add mode, and then the Answer Question form to open, which as far as I can tell is correct.

And therein lies your problem.

Change this to Open form in edit mode.