Form in Datasheet View

[brianborn]

I'm trying to create a form in datasheet view that can also show data in another table. View the link to see a screen capture of the table and you will see what I would like the form to look like. Also I have attached the image.

http://screencast.com/t/qxRvLNPd47Hd

This is a table view which has a lot more fields viewable than I want and the reason I need to create the form.

Can anyone help with some tips?

Brian

 

[rctjoe24]

I'm at work and can't view the link so I'm going from previous experience.

What I have done in this situation is to have a parent form with 2 datasheets (subforms) on it taking up as much of the page as possible each covering 50% of the area available. Then put an On_Current event of the top datasheet that sets a filter or changes the recordsource of the lower datasheet based on the record selected from the top.

Sometimes putting all the data together on one datasheet doesn't work, which is why I went this direction.

There's more than 1 way to achieving your goal.

 

[brianborn]

Thank you for the information. It's been a busy day here at work and this might have to wait until tomorrow morning to try it out. I like the option of having the + sign as it appears on the table to be able to open and collapse the details you want to see, but this form will be used by another person and they do not need to be confused with more data than they need.

Anyway, thanks again and I will test this out either tonight of tomorrow morning.

 

[brianborn]

...Then put an On_Current event of the top datasheet that sets a filter or changes the recordsource of the lower datasheet based on the record selected from the top.

I now have a blank form with 2 subforms, but I'm not sure what exactly I need to do to set the filter. I've made it far learning Access with the basics which includes tables, queries, forms, and reports, but really just venturing out with macros and VBA.

Some additional details that might make it easier to understand what I want to do. I'm a shipping clerk and have created my own database that I have used for almost a year now. It is time to expand and to allow another person to help with the shipping. This form would be most helpful if the other person could see the entire day's shipping in datasheet view. This is easy enough for me to do, but the part that confuses me is that some shipments will include multiple packages.

If you could help me with the code needed to accomplish this task, I would greatly appreciate it. I prefer to use macros as I eventually would like to publish it to the web. However, VBA will work too as the functionality is the most important right now. It's possible that I never migrate it to the web.

Brian