I have deleted a query in access and lost the data in a form?

[Trishauk]

I got into a bit of a mess by deleting a query that had a form linked to it
so deleted the query I made a new query and tried to link the data but there
is now no data ( records) in the form. Can anyone help please

 

[Tom van Stiphout]

On Wed, 10 Jun 2009 19:01:14 -0700, Trishauk

The best idea is of course to recover the query from a backup of your
database. You *do* keep backups, yes?
If yes, then you can use the import wizard to copy the query from the
backup to the production database.
If no, that's an expensive lesson, but moving on the first question is
if when you run your new query, does it show data?

-Tom.
Microsoft Access MVP

 

[John W. Vinson]

I got into a bit of a mess by deleting a query that had a form linked to it
so deleted the query I made a new query and tried to link the data but there
is now no data ( records) in the form. Can anyone help please

Correct the error in your query or in the way you have bound the form to the
query.

If you would like help doing so please post some information that would let
someone who cannot see your computer provide some useful advice: the SQL view
of the query, an indication of whether the query returns the needed records,
the Form's Recordsource property, perhaps the form's Data Entry property (it
should be No, this is a pretty common mistake).