table disconnected from form

[Bill L.]

I have an Access 2002 database for a musician's database of gigs, etc.
Somehow, the main table was disconnected from the form and I can't seem to
"reconnect" it. I tried using the properties to get the table connected but
the table shows up in the properties but the form doesn't show the data when
I run it. Any ideas?

Thanks, Bill L.

 

[Maurice]

Bill

I'm going to ask a stupid question first, is there any data in the table?

Now let's see if the form has any bound fields meaning are the controls
actually bound to the specified fields of the table?

Just for testing create a new form with a wizard where the table is the
recordsource for the form. If that works compare the original one with the
newly one created with the wizard.

Just some pointers...

 

[karl dewey]

--
KARL DEWEY
Build a little - Test a little

 

[karl dewey]

I tried using the properties to get the table connected but the table shows
up in the properties but the form doesn't show the data ....
Does the table show in the Record Source property or somewhere else?

 

[John W. Vinson]

I have an Access 2002 database for a musician's database of gigs, etc.
Somehow, the main table was disconnected from the form and I can't seem to
"reconnect" it. I tried using the properties to get the table connected but
the table shows up in the properties but the form doesn't show the data when
I run it. Any ideas?

Thanks, Bill L.

Check the Form's properties: if the Data Entry property is set to Yes, it will
let you enter new records but will not show existing ones.