Word Table in a Form?

[ramsayaj]

Hi there,

Is there anyway to create a table that hs the same features as a Word table in an Access form? I am looking for some way of allowing the user to insert and delete rows dynamically. I need to store the data with the record if at all possible.

I have tried messing with some of the ActiveX controls and OLE objects but I cannot get it to work.

Any ideas anyone?

Thanks,
Alan

 

[WayneRyan]

Alan,

What you want is a subform that is based on a "child" or
related table.

Main table has information something like:

CustomerNumber
CustomerName
CUstomerAddress ...

The sub-table has dynamic information like:

CustomerNumber
SalesDate
SalesAmount
SalesPerson ...

There are examples of this in the sample databases that
come with Access.

Wayne