how to export data from a table (by clicking in table) to a form

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

Guest

I have three tables Named Stock,Invoice & Approval Book. But I need only 2
forms to be print out i.e. Invoice and Approval Book. I need to put data from
table stock (by just clicking/double clicking) and data should be exported
to invoice or approvel book?
Thanx In Advance
 
I have three tables Named Stock,Invoice & Approval Book. But I need only 2
forms to be print out i.e. Invoice and Approval Book. I need to put data from
table stock (by just clicking/double clicking) and data should be exported
to invoice or approvel book?
Thanx In Advance
Click to expand...

STOP.

You're mixing jargon here.

Tables are for storing data. They have no usable events. You can't "click" a
table and have anything happen.

Access Forms are for on-screen interaction with the data in tables. You would
enter and edit data in your tables using a Form.

Access Reports are what you're calling a "form" - something printed onto a
sheet of paper.

The route you should take is to design properly normalized tables for your
data (see the links below if "normalized" is a new concept); create one or
more Forms to enter and edit the data; create a couple of Reports to print it;
and launch the reports from your Form.

John W. Vinson [MVP]
 
Back
Top