Use results from query on a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is probably something simple but I am trying to figure out how to take
the datasheet results from a query and copy that information onto a datasheet
on my form. Help please!!
 
jrusch said:
This is probably something simple but I am trying to figure out how to take
the datasheet results from a query and copy that information onto a datasheet
on my form. Help please!!
Click to expand...

You don't - you can't. Tables and queries (virtual tables) store data. Forms
are views into the tables/queries.

Create a new form in datasheet view using the wizard, selecting the query as
the record source. To use a current form, in design view, open the properties
window and change FORMS/DEFAULT VIEW to DATASHEET.

That is all it takes.

HTH
Steve
 
Back
Top