convert form datasheet to table in MS Access 2000

[Guest]

I have created a form in Access 2000 and can view the data in a datasheet
view. I would like to create a table that can be queried or reported within
Access but cannot figure out how to do so.

 

[Brett Collings [429338]]

Dave,
The form you have created will have a table behind it (if it has data
that is). This is called the RecordSource of the form.

When you open the Form in Design View, you should have the Properties
Sheet open. If it's not, go to the Menu View->Properties->Data
(Tab)->RecordSource and you will see it there.

Once you have that, come back with what you would like to do with it

Cheers
Brett