Control orphaned from back-end DB

X

XP

I have successfully split a database, but one of the buttons on my main menu
is supposed to open a form but its association is missing. I can see that
it's missing, but I can't figure out how to reassociate the control with the
back-end DB.

I already ran linked table manager and it successfully refreshed, but my
control is still orphaned, so the form it is supposed to open fails to open.

Office 2003 and Windows XP. Can someone walk me thru how to do this?

THanks.
 
X

XP

Please ignore my earlier post, it wasn't the button, but the underlying FORM
that had the problem; there was some garbage in the RowSource that when
cleared, fixed the issue. Sorry for the confusion.
 
K

Klatuu

It would help if you could describe what does or does not happen. if you get
a error, what is the error number and description, and where in the code does
it happen?

A control on the form has no relationship to the back end or any other
database. A control is a the forms' object collection. Until some action is
assigned to a command button through VBA, a Macro, or an expression, it will
do nothing. If your button should open a form, but the form is not opening,
then here are some things to check:
1. Look at the Click event of the control and determine what it is trying to
do. Since this is trying to open a form, be sure the form exists and the
name of the form is the same as the code trying to open it.
2. Check the record source property of the form. Ensure the query or table
that is the row source exists.
 
Top