Basic stuff with Access

Hey guys. I'm working in VBA with Microsoft Access to create a program that will be able to draw up quote estimations. Basically, a user will be able to select he features he/she wants and at the end, it will produce a little report with a cost estimation. I'm having two major problems.

1) I was wondering if there is a way I can create a grid on one of the tabs that will populate itself with information from the database. It would be a pain to have to create a text box and input box for each selection on each tab, since in one of the tabs, there are over 20+ selections. I'm trying to save time, as I have to have this done by Friday morning.

2) My second problem is, the program is a form with multiple tabs at the top. I need a way to implement a next button that will change between tabs. Any suggestions?

Thanks in advance!

P.S. I know I'm not being totally specific, I'm really rushed on time. If you need a specific question answered, I'll be watching this post like a hawk, so I should reply within seconds. Thanks again.

Access VBA.

I think your questions/issues will have a better audience with the VBA folks as opposed to the reports folks so I'm moving this to Office Automation.

In Access' toolbox you can add a Microsoft Data Grid Control to it if you have VB6 also installed. If not You might be able to load the VB runtime redistributable files to get it.

Hmmmm. No VB6, but I will try the runtime files. Thanks again.

Anyone have an idea for switching tabs?

VB Code:

Option Compare Database
 
Private Sub Form_Load()
    TabCtl0.Pages.Item(1).SetFocus 'clicks the 2nd tab
End Sub

:)

You might be able to do a subform on a tab (if you can, never tried it) that would give you enough of what you need from the grid, depending on what you need.