SPECIAL DESIGN ACCESS FORM

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

Guest

Hi,
I want to design a form that will look like this:

customer- taken from customer table and bring all the customer- it's text
field or label.

and at the bottom all the invoice of this customer- take from a query-shown
in table.

and again next customer and at the bottom again all his invoice in table.

i have 100 cutomer so i want it to show 100 text field\label with customer
name
and 100 table with all their invoice.

if I am trying to display the main form with Continuous Forms, i am getting
a messege box that said something like this (translated) you cant use
Continuous Forms with a form that has a table or active x

how can i do a form like decribed above?
Thanks in advnaced
Alon
 
I'm not sure why you would want to do this. You would not be able to see all
this information at one time unless you have a huge screen and a large field
of vision. Also, you would be using network and local PC resources to load a
lot of records.
 
ok, maybe i exaggeration
I have only Ten customers,
how do i do this?
thanks in advanced Alon
 
Hi Alon
As I answered in the other discussion group, I don't think you can define a
sub form in a continues form, only in a single form, so you don't have much
options but to create a report that display what you want and how you want.
And create a single form, to display the records and nmove from one customer
to the other using the NavigationButtons.
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck
 
Back
Top