data grid or something the same

[prostheticHead]

i need a way of entering lots of items into a form or viewing this list of items and editing them.

much like how the DataGrid in VB.net works ive been siting here scratching my head wondering why there isnt just a grid in access for entering data using a form.

list box Sort of dose what i want but dosnt update any records or add them it just displays a list of the Records which is fine for the viewing form but the editing form needs something like a dataGrid

anyone have any ideas?

if ya need more info just ask


Thanks Heaps!!

 

[prostheticHead]

this image should help explane what i mean and why I need this grid

 

[Rich]

Use a subform, either a continuous form or a datasheet

 

[prostheticHead]

ok i have a sub form and i have linked the child and master fields But when i try add a new line to the subform it Says "The LinkmasterFields Property setting has produced this Error: 'the object dosnt contain the automation object' tblInsurance."

then when iopen the QuoteItems table the item has been added but it has no RefNo.


if need be i can Zip up and send a copy of the database if anyone needs a closer look

 

[prostheticHead]

i just worked it out my Qurey was a little off

works sweet now

 

[prostheticHead]

I just checked if the relationship between the two tables had ERI ticked and its cool its was all ticked.

this is what ya mean isnt it?

thanks for the heads up though!