Pages

[clive2002]

I'm trying to write an interface for the update and addition of customer details in a database.

I so far have the below all on seperate forms.

CustomerListing - A list of existing customers.
CustomerDetails1
CustomerDetails2
CustomerDetails3
CustomerDetails4

dbl clicking a customer in the listing form takes you to CustomerDetails1 using the bookmark method and closes CustomerListing. Clicking "Next" in the customerDetails forms progesses thorugh the forms opening and closing as you go.

I'm happy with the way the listing form works, but moving between the various detail forms is a pain. Is there a better way to achieve this and prevent the user moving to the next record. I also want to block any changes being saved without my validation code being run at the last form, which will effect the validation rules for entries in the other forms.

I believe their maybe a pages option available in forms, but i don't know how to use it, is this the answer. I'd love something with page Tabs at the top of the form to flick between the detail sections.

 

[jaydwest]

What Version of Access are you using? I believe that Versions 2000+ have the tab control you want. If you are using 2000, 2002 then goto the form in design view. Display your Toolbox Buttons in the ToolBars. You'll find a Tab Control button (it looks like a tab file) on the toolbar.

If you're using an earlier version, there are 3rd party tab controls available.

Drag it down to your form and size it to create the Tab Control of your dreams.

 

[clive2002]

Thanks

I'm using 2000 and it works great, little ugly but who cares.

 

[clive2002]

PS

Whats the best way to look the record when using pages so the user can't move to another one.

 

[jaydwest]

Its a form Property. Open the property dialog box for the form and click on the Other tab.

Click on Cycle property and select Current Record.

That will do it for ya.

Good Luck!