change the form based on options button

[seangibson]

Is there a way to change the appearance of my form based on which option button is selected? I am using a form to input data into a table of transactions. There are basically 3 types of transactions (the type of which I would specify with an options button) and, though they all share common fields, some entries do not require all of the fields to be populated. For these I'd like for some of the combo boxes (my form uses combo boxes exclusively for data input) to not be visible. Is this sort of thing feasible or would I be better off just using Tab Controls? (Though I don't really want to take that option). I am using Access 2003.

[nico5038]

You can use the AfterUpdate event of the Frame holding the options to code a SELECT CASE like:

SELECT CASE fraOptions
Case 1
   Me.cmb1.visible = true
   Me.cmb2.visible = false
Case 2
   Me.cmb1.visible = false
   Me.cmb2.visible = true
end select
 

This will require all the fields to be set to true or false !

The tab control can be used and the buttons can be hidden.
Then the fields can be placed on three tabs and the correct tab can be activeted in the same AfterUpdate event by using the fraOptions value like:

Me.tabctl1.Pages(fraOptions).setfocus
 

Getting the idea ?

Nic;o)

[seangibson]

I'll have a look. Thanks. As a beginner, though, it may be a bit over my head.

[nico5038]

Then I would probably just use a tabcontrol and place the "specific" values per page.
The code I posted needs to be placed in events for the form. Looks "freightnin g", but is rather "easy".
To start you could define a new button with the button wizard, e.g. for opening another form, then you can inspect the created code by Access by clicking on the [...] button after the Procedure for the OnClick event in the properties window.

Nic;o)

[NeoPa]

I'll have a look. Thanks. As a beginner, though, it may be a bit over my head.

Nico's first solution in post #2 (Select Case ...) should precisely meet your requirements. It looks complicated first time but give it a go. We can always help some more if you don't understand it all clearly first time through.
What it's basically doing is showing or hiding ALL of your variable fields (those which are sometimes shown but sometimes hidden) depending on the selection of your option buttons (The fraOptions control there is referring to the Frame that the radio buttons are in. It's value will always reflect which button is selected).