Clicking on a record in a table to display a form

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

Guest

Hi,

I am trying to create a database that has a few table and forms. But the one
i am working on is a form that has a table that i created from a query made
into a sub form. The table was made from the form. I would like to be able
to enter the info on the form and then have it go away. Any suggestions
 
Hi,

I am trying to create a database that has a few table and forms. But the one
i am working on is a form that has a table that i created from a query made
into a sub form. The table was made from the form. I would like to be able
to enter the info on the form and then have it go away. Any suggestions
Click to expand...

I'm sorry, this is making no sense at all.

Tables cannot be "made from forms". A Form is just a window, a tool that lets
you see and edit data in its Recordsource table. Similarly, you can't "make a
query into a subform" - you can use the AutoForm wizard to create a new form,
using a table or a query as its recordsource.

What are the actual Tables (in the Tables tab of your database window)
involved here? What are the Forms and Subforms, and what are their
recordsources? Why would you want to enter data into a form and then have it
"go away" - what's the point of entering it if it's just going to be
discarded, or am I misunderstanding what you're asking?

John W. Vinson [MVP]
 
Back
Top