Switchboard

[a_gajic]

Well first of all, I'm a new member here so I would like to say Hi to everyone!

Next, for my question.

Why is it when I try to open a table from the switchboard the data that is in the database does not show up in the table?

At the minute, I have made a macro and linked the Switchboard to that so that it works properly.. I don't get it? What's the problem here does anybody know?

 

[David R]

Just a thought

But usually database users don't enter directly into a table, but into a form based on a table or query of a table.

What happens if you open the table directly from the Database Window? I cannot fathom why your table would look 'empty', unless it's gotten a random filter applied and saved to it. In the toolbar at the top there is a button for Remove Filter, see if that helps. Then close and save the table.

Otherwise, post back with more information; I'm having a hard time seeing what might be wrong.

 

[a_gajic]

Sorry!!! I didn't mean table. I meant form. God.. don't I feel stupid now?

Any ideas?

 

[David R]

Same sort of problems apply. Check that the form doesn't have a filter in place. If it's based on a query, make sure the query has the right data coming into it. If it's based on a SQL statement, copy that SQL into a blank query and see if the data comes up (better yet, click on the [...] and save the SQL as a query, then run it separately. It will run faster in the future this way.

Make sure the button on your switchboard doesn't include a WHERE clause.

 

[a_gajic]

from what you have told me, everything should work fine.. but it doesn't? Oh well, I'mhappy with the macro bit for the time being!

Thanks for your help

 

[David R]

How does your macro fix it?

That might give us a clue of what's wrong...

 

[a_gajic]

It's not based a query, SQL or got a filter applied to it.

All I done was used the Switchboard manager to tell it to open a form.. that's all.

 

[Treas]

Check that you're not opening the form in add mode - this will give you a blank form every time.

HTH