multi-row datasheet subform

[Dorian C. Chalom]

I am trying to create a grid like this and I would appreciate any guidence
you ca give...

Customer Code: (combo) Customer Name: (textbox display of customer)
Customer Location: (combo based on customer code)

(grid)
Supplier Name Supplier Location Distance
(supplier name)
(check box) (supplier location)
(check box) (supplier location)

I hope this explains it.

Thanks for your ideas and input...

 

[Kipp Woodard]

If you create a form for the customer table, and have a properly linked
subform on it for the supplier table, then when you view that form in
datasheet mode it should give you what you want. I am assuming that you are
using a version of Access that supports this.